|
|
Empty Cell Result by
Mike H.
In this if statement: IF(A1=100,1,"") I would like the 3rd parameter to not
return "", not return 0 but return NOTHING. Is there a way to return empty,...
|
|
8 |
115 |
|
|
|
April 13th, 2010 08:38 AM
by RTK
|
0 |
146 |
|
|
visible cell only by
Brad Autry
I'd like to use the PERCENTILE function in a list that has been autofiltered
and get the results based only on the visible cells.
I've used SUBTOTAL in order...
|
|
1 |
122 |
|
|
|
April 13th, 2010 04:37 AM
by Max
|
1 |
157 |
|
|
|
|
1 |
149 |
|
|
|
|
4 |
160 |
|
|
|
|
5 |
159 |
|
|
|
April 13th, 2010 02:37 AM
by JLatham
|
3 |
133 |
|
|
excel formula by
Brian
Does anyone know how to create a cell that will calculate whether the number
in the orginal cell is above or below 40. If above 40 it will calculate at...
|
|
6 |
137 |
|
|
Sum VLOOKUP? by
andyoftheg
Hi All,
I appologise if this function is currently avalible and i have missed it.
Is there a function or macro in Excel 03 which will effectivly provide the...
|
|
4 |
117 |
|
|
|
|
3 |
174 |
|
|
|
|
5 |
120 |
|
|
|
|
1 |
116 |
|
|
|
|
2 |
123 |
|
|
Lose Formatting by
[email protected]
We have a pretty intense Excel Workbook that we use on a daily bases.
We are currently running MS 2007 but this Workbook is running in
97-2003 because we just...
|
|
0 |
117 |
|
|
locate first value greater than by
MPI Planner[_2_]
I would like to be able to return the first column that has a number greater
than zero. For instance
3/2 3/9 3/16 3/23 3/30
Product A...
|
|
6 |
124 |
|
|
|
|
3 |
123 |
|
|
|
April 12th, 2010 08:37 PM
by JLatham
|
2 |
177 |
|
|
Average For Filtered Cells by
carl
I use the auto-filter feature.
Is there a formula I can use that will compute the average of the values in
a column for just the cells that are displayed...
|
|
1 |
138 |
|
|
|
|
8 |
192 |