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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to perform this operation?
See cpearson website
http://www.cpearson.com/Excel/lists.htm#Functions "Ayo" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a function to perform this operation?
Assuming the numbers are always positive.
Try this array formula** : =MIN(IF((MOD(ROW(D7:D277)-ROW(D7),30)=0)*(D7:D2770),D7:D277)) ** array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER. -- Biff Microsoft Excel MVP "Ayo" wrote in message ... 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. |
Reply |
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) |