Hello,
I'm looking for a way to return the value (or the column #) of the first instance in a row that meets certain criteria. For example:
Let's assume that I want to find the first instance in row 3 with a value greater than 15. I would like a formula that would either return the value of 20 (which is in Col C) or a column reference of 3 (related to Col C).
Col B Col C Col D Col E Col F
Row 3 5 20 15 25 22
Thanks in advance for your help!
Danny
I'm looking for a way to return the value (or the column #) of the first instance in a row that meets certain criteria. For example:
Let's assume that I want to find the first instance in row 3 with a value greater than 15. I would like a formula that would either return the value of 20 (which is in Col C) or a column reference of 3 (related to Col C).
Col B Col C Col D Col E Col F
Row 3 5 20 15 25 22
Thanks in advance for your help!
Danny