On the cell adjacent to say A1, say g1 , run a vlookup()

=if(vlookup(a1,sheet2!b1:b2000,1,false)=a1,"found" ,"n/a")
when done, apply an Data filter autoFilter, and use the column "G"
and alternate between "found" ones and "n/a" ones, you can format or
delete them as whole rows or else. Just one way of many, when done,
delete the vlookup(), it does add to the filesize and calculations.

Danny


On Mon, 11 Jul 2005 03:26:31 -0700, suki2shoes
wrote:


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





--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

comparing 2 spreadsheets
 

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

Hi,
assuming list A is in A1:A1000 on sheet 1
list B is in A1:A1000 on sheet 2

in B1 on sheet 1 put this formula

=IF(COUNTIF(Sheet2!$A$1:$A$1000,A1)0,"match","no match")

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=386077

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