Finding duplicates

  • Thread starter Thread starter John Menken
  • Start date Start date
J

John Menken

I am using Excel 2007. One of my columns has a long list of numbers in
it like what you see below. How can I see if there are any duplicates
in the list? Is there a function or something that will do this? Many
thanks.



22505505102
22505508413
22505504908
22505504822
22505505102
22505504954
22505514093
22505504840
22505514155
22505504917
22505504892
22505685859
22505505001
22505504933
22505508409
22505504844
22505504937
22505504893
22505505024
22505504937
22505504815
22505508448
 
John Menken said:
I am using Excel 2007. One of my columns has a long list of numbers in
it like what you see below. How can I see if there are any duplicates
in the list? Is there a function or something that will do this? Many
thanks.
Click to expand...

Select the column they are in > go to conditional formatting > highlight
cell rules > duplicate values

Your welcome

Tom
 
I am using Excel 2007. One of my columns has a long list of numbers in
it like what you see below. How can I see if there are any duplicates
in the list? Is there a function or something that will do this? Many
thanks.



22505505102
22505508413
22505504908
22505504822
22505505102
22505504954
22505514093
22505504840
22505514155
22505504917
22505504892
22505685859
22505505001
22505504933
22505508409
22505504844
22505504937
22505504893
22505505024
22505504937
22505504815
22505508448
Click to expand...

Free ASAP Utilities has a function to "Clear duplicates leaving one original
value" under "Range"
 
Assuming your list starts in A1, put this in B1:

=IF(COUNTIF(A$1:A1,A1)=1,"","Duplicate")

Then copy it down. The first occurence of a number will have a blank
in column B, and all duplicates will be marked as such. You could
apply a filter to column B to see all the duplicates (or delete them).

Hope this helps.

Pete
 
Back
Top