comparing 2 spreadsheets

[Danny]

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

 

[suki2shoes]

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

 

[greg7468]

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.

 

[Norman Jones]

Hi Suki,

See Chip Pearson's HighlightingDuplicates page at:

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

See particularly, Chip's 'Extracting Values On One List And Not Another'
section.