Automatic. I love when things are automatic. Cars. Bill pay. My dear husband's forgiveness of me...
Today's tip is quick, simple and easy!
Easy as pie, you might say.
You see - sometimes when working in Excel, you may be working with a large amount of data. And maybe you need every unique instance of a certain piece of data, but you might not need it repeatedly. So, wouldn't it be nice to drill down by removing any duplicates in your list?
Why yes. Yes it would be nice.
How do you do this, you might wonder - well, let me tell you.
All you need to do is to select your data range. Then go to to the Data tab on your menu bar and look for the Remove Duplicates icon.
A new box will pop up where you can say which row you want to look for duplicates in. You can also mark if there are headers in your selection so that they can be excluded from the search.
Once you have things set as you want them, click OK and it will remove all duplicates from your data set! Now you only have unique details in your list.
