| Home |
| Search |
| Today's Posts |
|
#4
|
|||
|
|||
Question: If my data is NOT in a contine cell, how can I run the formula? I can't get the Non-Continue Cell formula to work.
This formula does not work if the data cells are NOT continue: =SMALL(A1:A100,COUNTIF($A$1:$A$100,0)+1) What if my data are in cell A2, A6, C7, E9 How can I look up the Min function for these 4 cells: A2, A6, C7, E9 and exclude Zero ? I need to look up the smallest value for these 4 cells while exclude zero. Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using min function without calculating 0 as minimum | New Users to Excel | |||
| How do I set a minimum value to be returned from IF function | Excel Discussion (Misc queries) | |||
| Minimum function | Excel Discussion (Misc queries) | |||
| minimum function | Excel Worksheet Functions | |||
| Can I retrieve a value and its format using the minimum function? | Excel Worksheet Functions | |||
Threaded Mode
