If you’re working in Excel and only want to count unique occurrences, or if you want a quick way to delete all appearances of a duplication then DigiTip 75 will solve your problem! Did you know that you can automatically delete all duplications simply by using the function Data > Remove Duplicates. This will remove all duplications in the columns you selected.  

To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!