| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to perform this operation?
Let me see if I can explain this. I have these
range of cells: (D7,D37,D67,D97,D127,D157,D187,D217,D247,D277), and when I use the MIN() function =MIN(D7,D37,D67,D97,D127,D157,D187,D217,D247,D277) I get 0 because the values in the range are (1,5,0,5,0,0,1,3,1,2). But I want my result to be 1 because 1 is the next higher number to zero in the range. In the same instance, if the values in the range are (14,14,0,14,0,0,14,0,14,14) I want my result to be 14, because 14 is the next higher number to zero in the range. This is want I am trying to achieve. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I cannot perform this function PLEASE HELP! | Excel Worksheet Functions | |||
| perform 1 function, stop, perform different function | Excel Discussion (Misc queries) | |||
| Complex Macro to perform an operation as it steps down cells? | Excel Worksheet Functions | |||
| microsoft outlook unable to perform operation - send = receive. | Excel Discussion (Misc queries) | |||
| In Excel - a function or operation for "view visible cells" | Excel Discussion (Misc queries) | |||
Threaded Mode
