I'm just guessing that you want to flag duplicate numbers in col A
(Numbers are assumed within A1:A10000, and with the possibility of some
blank cells in-between)

Put in B1:
=IF(A1="","",IF(COUNTIF($A$1:A1,A1)1,"X",""))
Copy B1 down to B10000

Duplicate numbers, if any, will be flagged with an "X"

(We could then insert a new top row, and do a Data Filter Autofilter on
col B to filter out the "X", for example)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"dbmeyer" wrote in message
...
I have a very long column 10K of numbers. I need to identify each cell
which has a number before or after it which is equal to it.