Excel Forum

Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records

See how to use SUMPRODUCT and the Join Symbol (& Ampersand) to group duplicates and then see how to use Advanced Filter Unique Records to extract unique list from duplicates.

Got a Question? Ask it Here in the Forum.