| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I find the first non-zero cell
From left to right how can I get a formula that will find the answer to each
row as stated so the formula returns the first non-zero cell? 0 0 0 0 42.5 answer 42.5 0 0 0 4.74 0 answer 4.74 101.5 102 0 0 0 answer 101.5 99.975 101 0 0 85.188 answer 99.975 0 74.5 0 0 0 answer 74.5 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
| FIND / SEARCH text compare cell to string in 3rd cell | Excel Discussion (Misc queries) | |||
| find first empty cell in column and start transpose next row in that cell | Excel Discussion (Misc queries) | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
Threaded Mode
