Duplicate Entries

This query is : Resolved 

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
18 June 2011 How to find out Duplicate entries in excel???

18 June 2011 use Contol F to find duplicate entries

Avatar

Querist : Anonymous

Profile Image
Querist : Anonymous (Querist)
18 June 2011 Thats not possible as each entry involving huge database of thousand of entries may take couple of days??
Any other Option


22 June 2011 You can locate duplicates in a range of data by using conditional formatting and the COUNTIF function.

Here are the details on how to make that work.



LINK IS :-

http://office.microsoft.com/en-us/excel-help/locate-duplicates-by-using-conditional-formatting-HA001136616.aspx

22 June 2011 http://www.cpearson.com/excel/duplicates.aspx



You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join CCI Pro
CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries