|
|
Find if value exits in array by
Glynn
I need to determine if a numeric value held in a cell exists is a multy row,
multy column array of numeric values
--
Regards.
Glynn Taylor
|
September 5th, 2008 08:46 PM
by Glynn
|
6 |
103 |
|
|
SHOW AUDIT ARROWS by
ZOEY GREENE
how can I show viewers the audit trail arrows in a saved filed? say, when I
email an excel file, I want the recipients see the audit trail arrows when
they...
|
|
0 |
80 |
|
|
|
September 5th, 2008 08:32 PM
by Bourgui
|
0 |
107 |
|
|
sumif with a second condition by
jewel
Help please! I'm a beginner here and I have a working sumif function to
which I need to add a second condition. This second condition is to only sum
if the...
|
September 5th, 2008 07:46 PM
by jewel
|
6 |
107 |
|
|
Totaling cells in multiple worksheets by
JM
I am looking to total up the same cell from multiple worksheets within a
workbook.
For instance, if I have 10 worksheets (one being the summation...
|
September 5th, 2008 07:19 PM
by JM
|
4 |
72 |
|
|
|
|
2 |
68 |
|
|
Workbook Name Edited in Cell by
RoadKill
Good day,
I have this:
=MID(CELL("filename",A1),FIND("",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)
But how can I get the name of the Workbook in...
|
September 5th, 2008 07:11 PM
by RoadKill
|
1 |
60 |
|
|
|
|
3 |
92 |
|
|
multiple validations by
Koby W.
I have an excel file that has validation set up to choose numbers from a
list. In the column next to the numbers, I have a description of what the
numbers...
|
September 5th, 2008 06:58 PM
by T. Valko
|
2 |
113 |
|
|
|
|
1 |
70 |
|
|
Substitutions by
Amco
Column B has Department Names Column C has the department codes, the
department codes are the headings of columns F-H. What formula can I set that
will read...
|
September 5th, 2008 06:30 PM
by Sheeloo
|
1 |
57 |
|
|
Add "/" to a date string by
bpc
I have dates of birth entered into a column as 41384 which I would like to
insert the "/" symbol so that the dates read 4/13/84. The month never
includes a...
|
|
6 |
91 |
|
|
Dates and SumProducts by
Jeff Gross[_2_]
I have ~3000 lines of data. Column D includes an incident date for data
collected over the entire current year. Column E includes an incident type
(there...
|
|
2 |
80 |
|
|
SUMIF within a range by
Alonso[_2_]
i'm trying to check within a range (u5:ab94) if there are values
based on the content in column A
to identify if there is activity
but it only return a 1...
( 1 2)
|
September 5th, 2008 05:41 PM
by T. Valko
|
11 |
111 |
|
|
|
September 5th, 2008 04:54 PM
by Finny
|
3 |
87 |
|
|
Index backwards by
LiAD
I am trying to get a function to look backwards through a list to match two
text strings, then return a value that corresponded to the last entry. Example
...
|
September 5th, 2008 04:42 PM
by T. Valko
|
7 |
95 |
|
|
|
September 5th, 2008 04:32 PM
by Pierre
|
2 |
85 |
|
|
Pricing - Sliding Scale Price Markup by
Ed[_13_]
In Excel, I am looking for a formula to apply a sliding scale price markup
using interpolation.
The size of the percentage markup would decrease as cost...
|
September 5th, 2008 04:09 PM
by Ed[_13_]
|
9 |
119 |
|
|
Excel statistics by
ekonomija
Hello,
I would like to count sum of numbers if there is a condition, for example
Column A:
Product RADIO
Product CELL PHONE
Product RADIO
Product RADIO
|
September 5th, 2008 03:53 PM
by Wigi
|
1 |
112 |
|
|
|
September 5th, 2008 03:43 PM
by Spiky
|
1 |
74 |