Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract Unique Records from two lists
Hello,
I have two lists on separate sheets in a workbook. Each sheet contains both unique records and some records that occur on both sheet 1 and sheet 2 (there are never duplicates within the same sheet). I want to be able to create a master list on sheet 3 that includes only the unique records from sheets 1 and 2. Each sheet contains up to 20,000 records across 25 columns, meaning that I could be looking at a master list of 35,000 records. I have found and tried the array formulas listed on www.cpearson.com and while I can get these formulas to work, Excel keeps crashing when I try to use the formulas across so many records. I would appreciate any help with this. -- Thanks, MarkN |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique records with additional criteria | Excel Worksheet Functions | |||
filtering for unique records | Excel Discussion (Misc queries) | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Deleting specific records | Excel Discussion (Misc queries) | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |