Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find the rows existing in one column but not the other?
Hi,
I have a first worksheet containing 22000 rows of names and 50 columns of various data, and I have a second worksheet containing 16000 rows of names without any data columns, the names in the second worksheet are all in the first worksheet. Now I want to pick out those rows of names with all the data columns in the first worksheet which are NOT contained in the second worksheet, probably put them in a new worksheet. Please help. Best regards, Fred Zheng *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find the rows existing in one column but not the other?
in the 1st sheet:
Assuming Column A contains Names and Column B is empty (insert an empty column), put the following in B2 and copy down: =VLOOKUP(A2,Sheet2!A$2:A$16000,1,False) This will return the Name from Sheet2 (if found) or #N/A (if not found). You can use AutoFilter to quickly spot the records that have #N/A in columnB. What you do with them now is up to you: Copy, Move or nothing. HTH, -- George Nicholson Remove 'Junk' from return address. "Fred" wrote in message ... Hi, I have a first worksheet containing 22000 rows of names and 50 columns of various data, and I have a second worksheet containing 16000 rows of names without any data columns, the names in the second worksheet are all in the first worksheet. Now I want to pick out those rows of names with all the data columns in the first worksheet which are NOT contained in the second worksheet, probably put them in a new worksheet. Please help. Best regards, Fred Zheng *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert 5 rows between existing values in a single column 1 | Excel Worksheet Functions | |||
to find change and paste existing values/rows in excel with help of form | Excel Discussion (Misc queries) | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
macro to find something in column A and delete 5 rows below it | Excel Programming | |||
Use SUMPRODUCT to find duplicate rows (not one column) | Excel Programming |