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/