#1
|
||||
|
||||
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. |
#2
|
||||
|
||||
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. |
|
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 |
Return Max Text or Number Value based on Criteria | kwilson307 | Excel | 1 | 04-20-2017 05:07 AM |
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 |