| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comparing two ranges and extracting non duplicate data
Good morning everyone.
I am currently trying to compare 2 ranges with each other. One range is in column A and the other in column D. Column D contain more data than Column A. I want to compare the 2 ranges with each other and then extract all the data that are in column D, but not in column A and put them in a new column (F for example). It might sound really easy, but I have tried various if...then and do...while constructs, but it looks like I'm stuck logically. Does anyone have a clever idea of how to solve this? Any help is greatly apreciated. Thanks guys KJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Data Across Cell Ranges | Excel Discussion (Misc queries) | |||
| Comparing two lists and extracting data from one to another | Excel Worksheet Functions | |||
| Extracting duplicate data from two lists | Excel Programming | |||
| Comparing 2 rows for duplicate data | Excel Programming | |||
| Comparing 2 Columns for duplicate data | Excel Programming | |||
Threaded Mode
