=MATCH(A1,A:A)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"MLP" wrote in message
...
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
|