| 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 *** |
| 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 | |||
![Fred[_26_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
