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:

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]123
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]456
[/TD]
[TD]34
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]456
[/TD]
[TD]56
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]123
[/TD]
[TD]78
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]789
[/TD]
[TD]910
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]456
[/TD]
[TD]1112
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]789
[/TD]
[TD]1314
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]789
[/TD]
[TD]1516
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]123
[/TD]
[TD]1718
[/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]123
[/TD]
[TD]12
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]456
[/TD]
[TD]34
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]789
[/TD]
[TD]910
[/TD]
[/TR]
</tbody>[/TABLE]

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..