Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I choose first value greater than 0?
I have a worksheet with data by month in columns. I want to look through the data consecutively and find the first value greater than 0 in each row.
I can do this with an imbedded if statement, but I did not know until recently that you can only have 8 IF's. So it takes two if formulas, the first with 8 IFs the second with five, one to compare to the result of the first IF formula and the rest to check the final 4 months of data. I tried to figure out a way to use the CHOOSE option to make this work but had no success there. Is there a better way to do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I choose first value greater than 0?
Hi,
Take a look at Tom's solution in following post, http://groups.google.com/group/micro...91947f4f49f236 and adjust to your needs ... HTH Cheers Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I choose first value greater than 0?
Hi!
Try this: Entered as an array using the key combination of CTRL,SHIFT,ENTER (not just ENTER): =INDEX(B1:M1,MATCH(TRUE,B1:M10,0)) Biff "jagruc" wrote in message ... I have a worksheet with data by month in columns. I want to look through the data consecutively and find the first value greater than 0 in each row. I can do this with an imbedded if statement, but I did not know until recently that you can only have 8 IF's. So it takes two if formulas, the first with 8 IFs the second with five, one to compare to the result of the first IF formula and the rest to check the final 4 months of data. I tried to figure out a way to use the CHOOSE option to make this work but had no success there. Is there a better way to do this? -- jagruc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Values from an Array | Excel Worksheet Functions | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions |