View Single Post
 
Old 11-15-2021, 06:40 AM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Attached Files
File Type: xlsx GapRowNumber.xlsx (13.0 KB, 12 views)
Reply With Quote