Advanced Filter to the rescue.
Quick, highlight your list of items. Or, click on the whole column. Now, click on Data-->Filter-->Advanced Filter.
You will see this dialog box:

Click on "Copy to another location"
Doing that will un-gray the "Copy to" box. Use your zoomy box to choose where your list with unique records only will reside. Now, click the "unique records only" box. Hit OK. You're done. Now, you have a comprehensive list of unique items.
Quick and Easy.
No comments:
Post a Comment