Just another twist:-

With your data in A1:A10000

in B2 put =AND(A2=A1,B2=A3)

and copy down.

Then just filter on TRUE

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


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