John,

Use a helper column of formulas: in a cell in row 2, enter the formula

=OR(A2=A1,A2=A3)

and then copy down to match your data. Then filter on that column to show TRUE values only.

HTH,
Bernie
MS Excel MVP


"How did I get here?" <How did I get wrote in message
...
My machine names are in the first column in a spreadsheet. I need to find or
flag in some way, those instances in which a machine name in one row
is followed by the same name appearing again in the next row's first column.


It would be fine (but not necessary) to reveal this by deleting all other
rows
that do not repeat in this way.

Thanks,
john c