Excel Forum
Similar Content
UNIQUE() Function - Excel 365 Function for Removing Duplicates
Tutorial: Excel 365 Formulas Course The new UNIQUE() function for Excel 365 allows you to quickly, ...
Make Your Macros Available in All Workbooks in Excel
Tutorial: In Excel, you can make it so all of your macros can be easily accessed by any Excel work...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.