| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return the first value in a column
Ben เขียน: What would be the most efficient way of returning the value of the first NON-ZERO value in a column. THANK YOU If A2:A11 contain your data. B2 =INDEX(A2:A11,MATCH(1,(A2:A110)+0,0)) Ctrl+Shift+Enter Hope this helps. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Return the column | Excel Worksheet Functions | |||
| Lookup in one column, and return value from another column | Excel Worksheet Functions | |||
| Search one column and return value from next column | Excel Discussion (Misc queries) | |||
| How to return value from last column w/value? | Excel Worksheet Functions | |||
Threaded Mode
