Thanks a bunch. I found 699 instances which a customer back charged us 2X
for the same serial number.

"Biff" wrote:

Hi!

One way:

Assume the numbers are in the range A1:A10000 with no empty cells within the
range:

Enter this formula in B1:

=IF(A1=A2,"X","")

Enter this formula in B2:

=IF(OR(A1=A2,A2=A3),"X","")

Double click the fill handle to quickly copy the formula down to B10000.

Biff

"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.