Fnd first instance of value in Column A, then add Row to list on another sheet

[Alexandroid]

Hey everyone! I have a large spreadsheet that has repeated values in Column A but unique Values in Column B, and I would like to find the first instance that one of the repeated values appears in column A and copy the entire row to a new sheet. I would like to create an entire list with each value in Column A without repeating them.

Example:

	A	B
1	123	12
2	456	34
3	456	56
4	123	78
5	789	910
6	456	1112
7	789	1314
8	789	1516
9	123	1718

<tbody>
</tbody>

That would be the original list. On the other sheet, Only the following would appear:

	A	B
1	123	12
2	456	34
3	789	910

<tbody>
</tbody>

I hope this makes sense! I believe that I need to use a combination of Index and Match and I've found very similar questions all over the internet but I just can't get it to work.

Thank you for your help!

Alex

 

[VBA Geek]

hello, you can simply copy the column A in a new sheet, remove duplicates then use VLOOKUP to return the first instance

hope it helps..