software

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?See

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

Last paragraph: Extracting Values On One List And Not Another

--
Kind regards,

Niek Otten

gt; wrote in message oups.com...
gt;I just received two spreadsheets that have the same information but the
gt; columns are not symmetrical. It's about 400 rows and I'm told to find
gt; the missing rows. Is there an easier way to do this than sorting both
gt; by alphabetical order and printing them out and marking off each with a
gt; pen?
gt;
One way to do this is to determine a data point on each row that is
common to both spreadsheets. It may be a customer name, account
number, something like that. Then use a COUNTIF formula that counts
the occurences of that data point on the other spreadsheet. Any zeroes
that result from the COUNTIF are missing on the other spreadsheet.

Impress your boss: perform this operation on *both* sheets to make sure
you have captured all the data.