Searching specify data

[ªÎ¿°¤H@work]

Dear all,

I have an execl file, which have sheet1, sheet2 and sheet3.
There are some same data, text or numeric, which appears on both of the
worksheet. Is there any easy method which can search all those same data
out?

I am now using Find on each worksheet for searching specify data out.

Thanks for all help.

William

 

[Dave Peterson]

You could look for duplicates between two columns using the techniques at Chip
Pearson's site:
http://www.cpearson.com/excel/Duplicates.aspx