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 :-

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

22 June 2011 https://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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro

Follow us
add to google news


Answer Query



Company
29 June 2026
Accountant (Finance & Compliance)

TRIEYEZ

Kolkata

CA

View Details
Company
19 June 2026
Accounts Executive

Getfive Advisors Pvt. Ltd.

Ahmedabad

CA Inter

View Details
Company
25 June 2026
AUDIT MANAGER

JDAS & ASSOCIATES

New Delhi

CA

View Details
Company
22 June 2026
Accountant

Global Image Technologies Private Limited

New Delhi

MBA

View Details
Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
20 June 2026
Assistant Accounts Manager

Fintax Professionals

Gurgaon

CA Inter

View Details
Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details