ExcelBanter - To find duplicates in XL sheet?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - To find duplicates in XL sheet? (https://www.excelbanter.com/excel-worksheet-functions/162763-find-duplicates-xl-sheet.html)

Ina Andersson

To find duplicates in XL sheet?

After sorting a big table I need to find the duplicates that appears in a
special column? Do anybody know?

Mike H

To find duplicates in XL sheet?

Hi

Select your data (in this example A1 - A100) then click

Format|conditional format
select formula is
enter this formula
=COUNTIF($A$1:$A$100,A1)1
Pick a colour and duplicates will be hughlighted.

Mike

"Ina Andersson" wrote:

After sorting a big table I need to find the duplicates that appears in a
special column? Do anybody know?

All times are GMT +1. The time now is 05:06 AM.