Srinivasrao New Member Aug 25, 2012 #1 In my excel file in a column there are few hundred names. How check the duplicate entries.
M mercatog New Member Aug 25, 2012 #2 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 Code: {=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
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 Code: {=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 Excel Ninja Staff member Aug 25, 2012 #3 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.
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.