| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find first nonzero value in column
I have two columns A and B. Column A contains ascending numbers from 1 to
100, Column B arbitrary numbers. I am looking for a function that looks for the first nonzero value in column B (going from the first to the last row) and then returns the value from column A of the same row. Can somebody help me? Thanks, David |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| how do I find an average number of specific words in a column | New Users to Excel | |||
| find LAST match in column | Excel Worksheet Functions | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
| Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions | |||
Threaded Mode
