Does anyone know of a function or formula that I can use to return the cell number of a cell with a specific value in a given range?
For instance in cells A1:A30 I want to know the cell number (A3, etc.) of a cell that contains the value "RENEW."
Thanks, MK
For instance in cells A1:A30 I want to know the cell number (A3, etc.) of a cell that contains the value "RENEW."
Thanks, MK