Duplicate Entries

This query is : Resolved

Report Abuse Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

18 June 2011 How to find out Duplicate entries in excel???

prasad

prasad (Expert)
Follow

18 June 2011 use Contol F to find duplicate entries

Querist : Anonymous

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

Upgrade to CAclubindia Pro. Subscribe Now!

RAMESH KUMAR VERMA

RAMESH KUMAR VERMA (Expert)
Follow

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

RAMESH KUMAR VERMA

RAMESH KUMAR VERMA (Expert)
Follow

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