Finding Duplicate entries in a list of data is one thing but being able to remove them can be quite time consuming unless you know the tricks in Excel.
This tutorial uses a list of English Premiership football matches to generate a list of teams in the league. It does not use any equations and you could master this technique in a matter of minutes.
The contents of this tutorial can be used to get a list of unique customers from a sales sheet, remove duplicate emails address from a mailing list or 1 of 100 other uses. Have a look at let me know how you may want to use this technique on the feedback page.
|
