kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have a few sheets with a long list of duplicate values and the total list is more than 2.5 million. Example is 5 sheets and each sheets have about 500,000 of values. I need to produce a final list of all 5 sheets unique values , meaning there should not be any duplicates with the total list from all 5 sheets combined values.
Normally I would just combine all list in one sheet and use the UNIQUE function to extract the unique values. Since Excel can only accommodate up to 1 million in one sheet, is there another way to accomplish this ?
I have a few sheets with a long list of duplicate values and the total list is more than 2.5 million. Example is 5 sheets and each sheets have about 500,000 of values. I need to produce a final list of all 5 sheets unique values , meaning there should not be any duplicates with the total list from all 5 sheets combined values.
Normally I would just combine all list in one sheet and use the UNIQUE function to extract the unique values. Since Excel can only accommodate up to 1 million in one sheet, is there another way to accomplish this ?