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.
Automatically remove duplicates in Excel with a formula
You don’t have access to this lesson
Please purchase this course, or sign in if you’re already enrolled, to access the course content.