Delete rows if same ID exists more than twice

[BradleyS]

I have a list of numbers in column A which are all sorted as follows, and there is other data in columns B to E

43
43
43
56
76
76
83
83
83
83

I only want to see the earliest 2 unique numbers of each. Where there is more than 2 the remaining matching ROWS (A to E)need to be deleted. Therefore in the example above is should look like:

43
43
56
76
76
83
83

Having less than 2 is fine, but no more than 2. Is this possible?

 

[AlanY]

put this in H1, a dummy column H, say, and copy down

=COUNTIF($A$1:A1,A1)

then put a filter in Row 1 and delete all rows with 3 or higher in Col H

 

[BradleyS]

Thank you I might be able to work with that.

 

[AlanY]

you're welcome