Duplicate entry

[Srinivasrao]

In my excel file in a column there are few hundred names.

How check the duplicate entries.

 

[mercatog]

Hi

If you have Excel 2007 and later, you can use Format condition (the 5th item). Sorry I don't have english version of excel to help more


Here is an array formula which will show you how many duplicate values you have in a range

{=COUNTA($A$1:$A$1000)-SUMPRODUCT(IF($A$1:$A$1000<>"",1/COUNTIF($A$1:$A$1000,$A$1:$A$1000)))}

Validate this formula with Ctrl Shift Enter


Regards

 

[Hui]

Srinivasrao


Firstly, Welcome to the Chandoo.org forums.


I'd suggest starting by using the Google Custom search box at the top right of this page.

Chandoo has written several posts on finding Duplicates.