Return column number of specific value
Posted by Zif on August 09, 2001 2:46 AM
I recently read a message on this board regarding returning the column number of the maximum value in a range of cells.
What I need is slightly different. I have (for example) a range of cells C1:J1 which will contain the text value "No", but one (and only one) cell will contain the text value "Yes".
What I need os a formula to return the column number of the cell containing the value "Yes"