How to find the unique records from the data list
Here is an example on the need to find out unique records from a given list.
Assuming you are given a list of customers staying in different locations. In the given list, we need to find these locations so that we could present a summary on the number of customers living in each and every location in this list. How do we obtain this list quickly and accurately? Excel provides such a solution, using a function that is not commonly used by most excel users. It is the advanced filter function. Here is
how we can get the unique list of locations using the advanced filter function.
a. Select the range you want to generate your unique list of locations
b. Go to menu, select data -> filter -> advanced filter.
c. In the range box, you will notice that it has been filed in with the selected range.
d. Selected the option: Copy to anther location.
e. Make sure that the input box labelled criteria is empty.
f. In the copy to box, enter the cell you want to present your results.
g. Check on the box "unique records only"
h. Click ok.
New! CommentsHave your say about what you just read! Leave me a comment in the box below.
Share this page:
Enjoy this page? Please pay it forward. Here's how...
Would you prefer to share this page with others by linking to it?
- Click on the HTML link code below.
- Copy and paste it, adding a note of your own, into your blog, a Web page, forums, a blog comment, your Facebook account, or anywhere that someone would find this page valuable.
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft