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.