I am attempting to find a formula where I can look at a column range within a row and return the column header in that row where the first non-zero value occurs, moving left to right.
Below is a screenshot of my data:
The results I would want to see in column H would be as follows, for each row:
9 = 10/31/2011
10 = 11/30/2011
11 = 11/30/2011
12 = 12/31/2011
I have played around with some array formulas and searched through functions, but have not found any sucess yet. I am hoping another excel wizard may have an idea.
I want to avoid writing a UDF for now, if I can.
Answer
Sure, try this
=INDEX(J$8:N$8,MATCH(TRUE,INDEX(J9:N9<>0,),0))
No comments:
Post a Comment