|
Posted to microsoft.public.excel.misc
|
|
|
Compare data in 2 worksheets
Thank-you for your help!
"Peo Sjoblom" wrote:
http://www.cpearson.com/excel/Duplicates.aspx
also same site under downloads has a program called compare for downloading
--
Regards,
Peo Sjoblom
"MikeB" wrote in message
...
I have two worksheets of data. Columns A contain the same data in each
workbook (ID #'s). I need to find out if the data in Worksheet1 Column A
is
in Worksheet2 Column A. I would like the rows to display a N/A if the
data
is not in the other worksheet. Does anyone know the formula(s) needed to
get
this result?
|