An Excel Formula to Generate a Column with Unique Data/Entries.

Posted on January 24, 2008
Filed Under Excel Tips & Tricks

New to the World of Office, XP and Vista Tips & Tricks?

Here are a few posts the other readers recommend you check out.

This article is a very valuable for when you are sorting your data in Microsoft Excel. It frequently happens that people (like me) have huge lists of entries that we need to sort out. And this can be a nasty job if you don’t know what you’re doing.

In today’s Microsoft Excel Tip and Trick I would like to show you how you can filter all the double entries and move them to another column, this way you are not losing any data that might be important.

Here’s a Microsoft Excel tutorial to remove all duplicate entries in your spreadsheet.

First you’ll need to select the column that you want sorted; in this case column A.
Now go to Data
And Click on Advanced (filter)

Excel-tip-trick-pic1

In the Advanced Filter Window you’ll need to check mark the option “Copy to Another Location”.
Type in the field “copy to”: B1
And checkmark the option “Unique Records Only”.

Excel-tip-trick-pic2

And press OK

Now all the single valued data is in the column B and you can process this any way you like.

I hope you all liked this very very useful Excel Tip and Trick. Talk to you all tomorrow.

Do you want to see more? This is related...

Did you ever thought about publishing your own eBook or PDF report?

Invite your friends to the World of Office.

Grab the Easy PDF Toolkit, it was never this easy! If you invite your friends and we will receive at least 3 visitors then you will receive a free copy of this amazing kit and that is including all the cool bonuses. Invite your Friends here!

If you liked this article or you thought it was helpful then you would do us a real big favour by hitting one of the below icons. Thank you!! That’s really cool and we really appreciate your support.