Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-15-2021, 06:40 AM
Marcia's Avatar
Marcia Marcia is offline Find the row number based on criteria Windows 10 Find the row number based on criteria Office 2019
Expert
Find the row number based on criteria
 
Join Date: May 2018
Location: Philippines
Posts: 450
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, 8 views)
Reply With Quote
  #2  
Old 11-15-2021, 10:13 PM
Marcia's Avatar
Marcia Marcia is offline Find the row number based on criteria Windows 10 Find the row number based on criteria Office 2019
Expert
Find the row number based on criteria
 
Join Date: May 2018
Location: Philippines
Posts: 450
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

I've finally got the correct result by inserting 4 helper columns. Is there a neater formula in Column H without the helper columns E, F and G?
Thank you.
Attached Files
File Type: xlsx GapRowNumber.xlsx (12.4 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Least of Criteria based on Tenure & Age hiwire03 Excel 1 06-02-2019 12:03 AM
VBA - Deleting Rows (criteria based) BobbyG Project 1 07-31-2017 08:55 AM
Formula to return a value of 1,2,3 or based on a set criteria Highlander01 Excel 7 06-02-2017 01:17 PM
Find the row number based on criteria Return Max Text or Number Value based on Criteria kwilson307 Excel 1 04-20-2017 05:07 AM
Find the row number based on criteria Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. phillipsdp Excel 1 11-09-2016 12:53 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft