Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
Comparing contents of two spreadsheets and outputting results to a | Excel Worksheet Functions | |||
Comparing Spreadsheets | Excel Worksheet Functions | |||
Please Help (Comparing Spreadsheets) | Excel Worksheet Functions |