Automatically remove duplicates in Excel with a formula

Please sign up for the course before starting the lesson.

Occasionally you may need to create a template that automatically 'removes' duplicates from a list. Normally it is not possible to delete rows in Excel without using a macro, but you can set up formula to create a separate list that only brings through the unique items, thereby automatically 'removing' the duplicates from this new list.

Back to: Data cleanup in Excel > Identify and Remove duplicates in Excel