| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding non-zero value
I would like to be able to test a row in a matrix for a non-zero value. When
I find the non-zero cell I want to return the value of column heading. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding non-zero value
=INDEX(A1:O1,MATCH(TRUE,A2:O2<0,0))
where headers are in A1:O1 and the values in A2:O2 adapt accordingly to fit your own data needs to be entered with ctrl + shift & enter -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Tom Stout" wrote in message ... I would like to be able to test a row in a matrix for a non-zero value. When I find the non-zero cell I want to return the value of column heading. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding non-zero value
Hello Peo,
Thanks for the information! One more thing, the formula below returns the first value and the first header, how do I return multiple headers for multiple values? Thank you. Jim "Peo Sjoblom" wrote: =INDEX(A1:O1,MATCH(TRUE,A2:O2<0,0)) where headers are in A1:O1 and the values in A2:O2 adapt accordingly to fit your own data needs to be entered with ctrl + shift & enter -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Tom Stout" wrote in message ... I would like to be able to test a row in a matrix for a non-zero value. When I find the non-zero cell I want to return the value of column heading. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCEL 2003 IS NOT FINDING MY EXCEL 2000 FILES FROM A CD | Excel Discussion (Misc queries) | |||
| Finding Asymptotes from a set of data in Excel | Excel Worksheet Functions | |||
| Finding Asymptotes from a set of data in Excel | Excel Discussion (Misc queries) | |||
| Filter not finding all cells in columns | Excel Worksheet Functions | |||
| Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
Hybrid Mode
