Help

[Erin]

I have a problem. I have a list of numbers that are in one column.
Alot of numbers 8000 or so, and I need to find if there are an
duplicates. I sort them so that they are in order, but having t
scroll through the whole list takes alot of time and hurts my eyes!!
I tried advanced filter but I can only find how to find duplicates in
different columns.
Someone help me please!

 

[Jeff]

Insert a column next to your number column and put a
formula in it that subtracts itself from the row above
it. Drag the formula down to the rest of the column.
Turn on autofilter and any 0's you have in the formula
column would indicate a duplicate (making sure your
numbers are sorted in order).

-----Original Message-----

I have a problem. I have a list of numbers that are in one column.
Alot of numbers 8000 or so, and I need to find if there are any
duplicates. I sort them so that they are in order, but having to
scroll through the whole list takes alot of time and hurts my eyes!!
I tried advanced filter but I can only find how to find duplicates in 2
different columns.
Someone help me please!!


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements