Assuming your values start ar row # 2 (even numbered) use this formula
=IF(MOD(ROW(),2)=0,A2=A3,A1=A2) and fill it down



"yusee_ygs" wrote in message
...
I would like to compare the rows 1 and 2 (names) and have a logical value
returned. Is there a way to do this so that it compares only row 1 and 2,
3
and 4 and not 2 and 3...
I have 1500 rows of the names and I would like see which rows have the
exact
names and which dont.
Please guide. Thanks

Kat Warren
Kat Warren
McKenney James
McKenney James
Yelli Albert
Yelli Albert
Green Stephen
Green Stephen
Block Stanley
Block Stanley
Steigbigel Roy
Steigbigel Roy