See

http://www.cpearson.com/excel/duplicat.htm#Replacing

Last paragraph: Extracting Values On One List And Not Another

--
Kind regards,

Niek Otten

wrote in message oups.com...
I just received two spreadsheets that have the same information but the
columns are not symmetrical. It's about 400 rows and I'm told to find
the missing rows. Is there an easier way to do this than sorting both
by alphabetical order and printing them out and marking off each with a
pen?