Match Formula, Find next duplicate

[D3allamerican07]

I have two groups of data I am trying working with. In each group, there is a column with a unique value. I am trying to match those values together and then sort so I get a 1-to-1 match on rows.

Unfortunately, there are duplicates, so when applying the formula, =IF(COUNTIF(H:H,Q2)>1,"Duplicate",MATCH(Q2,H:H,)), I cannot sort properly.

Q2 = Lookup Value
H:H = Range

Is there a way I can either before, during, or after applying the formula:

1. Find the matching row number
2. If there is a duplicate, find the first matching row number
3. then the second matching row number
4. then the third,
5. etc.

Thank you in advance!

 

[Rijnsent]

Hi Bill,
what you could do is a formula like:
=COUNTIF(H$1:H2,Q2) and drag that down (notice the $). You'll basically get a number for every row, showing how many times that value has occured in that row or above. That should help you getting to the n-th value.
Cheers,
Koen