| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using MATCH to find the 2nd match, not only 1st
I have a set of data of people and their corresponding registration numbers.
This list is over 9000 rows long and many names can be duplicates if someone registered two different times over the course of a year. I currently have a formula set up to find the person (based on an another list) using Index/Match. I can always find the first matching occurence using Match, but in the case where someone registers more than one time, I can't get the second matching registration number. Any ideas? Peters Carol 345122 Peters Carol 345141 peters katie 333496 Peterseso Abby 375938 Petersmark Jennifer 392800 Peterson Aaron 371537 Peterson Amy 364819 Peterson Cornelia 352957 Peterson eric 443652 Peterson Jake 400413 Peterson Jeromey 371646 Peterson John 327468 Peterson John 362066 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and match totals Genius Req. this should be easier to read | Excel Worksheet Functions | |||
| Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
| Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) | |||
| Find last match in vllokup | Excel Discussion (Misc queries) | |||
| Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Threaded Mode
