Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help Returning the cell addy/index of the first non-zero number
I'm trying to return the location of the first non-zero number in a row. Example: A B C D E F G H 0 0 0 3 0 8 9 10 In the above example, I need to figure out if it's possible to used functions to return the index or cell address of the first non zero number. So in my example above, I need the function to return either the address of D1 or the index position of 4. Any help would be great. thanks -- Dreamer |
#2
|
|||
|
|||
For the position...
=MATCH(TRUE,A1:H1<0,0) For the cell address... =CELL("address",INDEX(A1:H1,MATCH(TRUE,A1:H1<0,0) )) OR =ADDRESS(ROW(A1:H1),MATCH(TRUE,A1:H1<0,0),4) These formulas need to be confirmed with CONTROL+SHIFT+ENTER. Hope this helps! In article , Dreamer wrote: I'm trying to return the location of the first non-zero number in a row. Example: A B C D E F G H 0 0 0 3 0 8 9 10 In the above example, I need to figure out if it's possible to used functions to return the index or cell address of the first non zero number. So in my example above, I need the function to return either the address of D1 or the index position of 4. Any help would be great. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |