comparing 2 spreadsheets

[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/duplic...tingDuplicates

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

---
Regards,
Norman



"suki2shoes" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>

[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


On Mon, 11 Jul 2005 03:26:31 -0700, suki2shoes
<[email protected]> 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/