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.
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft