Duplicates (MSOFFICE 97SR2)

Topic

New Reply

I have a spreadsheet with 30,000 rows, in coloumn A are 9 digit code numbers, some of them are duplicated is there a way to identify and exctract the duplicate rows (not delete them) just extract them.

Thank’s in anticipation

Reply | Quote

Replies

Say your data are in A2:A30000.

In any column, enter this formula:

=COUNTIF($A$2:$A$30000,A2)

Now you can use data, filter, autofilter.
Click on the countif column’s dropdown, select custom and make it show items greater than 1 to reveal the duplications.

Reply | Quote

Thank you very much it worked very well.
Braddy60

Reply | Quote

<>

Hey, watch it, I’m forty!

Reply | Quote