Double Numbers

  • Thread starter Thread starter Erin
  • Start date Start date
E

Erin

I have a question.
I have a series of 5 digit numbers in a spreadsheet. About 4000 o
them, and I need to find out if there are any doubles. I sort by th
column they are entered in and it puts the doubles together, but
still have to scroll through every number and visually find them. I
there any way I can do this without looking at each one?
Please say yes!
 
Alan-
Thanks for the website. It will be helpful in the future. However,
still can't figure a way to do what I need to do. The only thing
could find was how to filter for matched data in TWO colums and m
numbers are entered into one column.
Any other ideas?
Thank
 
Erin,
Go Advanced Filter and highlight your list, select Unique Records
Only, select Copy To Another Location and enter a cell in an empty column >
OK
You now have your list with all the duplicates removed,
HTH,
Alan.
 
Erin

One method........

Assuming the numbers are in Column A.
Sort Column A.
In B2 enter =A2=A1
Drag/copy down Column A
This will result in TRUE if same and FALSE if not same.

Autofilter on TRUE to find the second instance of each number if one exists.

What you do with them when you find them is another question.

Gord Dibben XL2002
 
Back
Top