Hi Suki,
See Chip Pearson's HighlightingDuplicates page at:
http://www.cpearson.com/excel/duplic...tingDuplicates
See particularly, Chip's 'Extracting Values On One List And Not Another'
section.
---
Regards,
Norman
"suki2shoes" wrote
in message ...
Hi
i have two spreadsheets with thousands of telephones numbers in them.
i need to find out which numbers from one of the spreadsheets appear in
the other spreadsheet.
so basically, which numbers from A appear in B
there are thousands of numbers so icant do it manually.
thanks for any help
--
suki2shoes
------------------------------------------------------------------------
suki2shoes's Profile:
http://www.excelforum.com/member.php...o&userid=25024
View this thread: http://www.excelforum.com/showthread...hreadid=386077