To find duplicates in XL sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After sorting a big table I need to find the duplicates that appears in a
special column? Do anybody know?
 
Hi

Select your data (in this example A1 - A100) then click

Format|conditional format
select formula is
enter this formula
=COUNTIF($A$1:$A$100,A1)>1
Pick a colour and duplicates will be hughlighted.

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Augmenting an integer in a column to reflect duplicates in another 23
How to filter Unique values from Duplicates 6
Highlight Duplicates, Macro? 6
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
is there a simple formula that will remove all duplicates 3
Finding duplicates 2
How do I find (not delete) duplicates in multiple spreadsheets? 1
Access Compare records in same access table 0

Back
Top