| 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, while Column B contains arbitrary values. I am looking for the function that finds the first nonzero value in column B (going from first to last row) and then returns the value of column A of the same row. (This request might be posted twice). David |
| Reply |
| 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) | |||
| find first nonzero value in column | Excel Worksheet Functions | |||
| 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 | |||
Linear Mode
