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.

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.

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.