Finding non-zero value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting blank cells globally 8
Minimum non-zero value 3
average of non contigous data to also exclude zeros 14
How to count the maximum number flanked by zeros 9
how to return random non zero value to a particular cell? 5
output row number for corresponding non-zero value of match functi 2
null vs zero in regression analysis 2
Average non-adjacent cells & exclude zeros 3

Back
Top