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