Find the row number based on criteria
Hi all. I would like help in a formula that will return the location of a missing number in a series.
I have tried a formula in Column1 using the IF and AND functions but it is giving a wrong result.
Attached is a sample sheet. Thank you.
|