In this article we will learn how to filter the data for the list of unique records only in Microsoft Excel. We will use the Advance filter option for the same.
Let’s take an example and understand:
We have date wise sales data of few agents. Here, we want to put the filter on the name range but the same name is repeated in the list and we want a unique list of names, where none of the names are repeated.
Follow the steps given below:
How to clear the filter?
Follow the steps given below:
And, in this way we can put the filter for unique records in Microsoft Excel.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"When I reduce my sheets to 75%, the numbers don't stay aligned. The difference spaces between a 1 and a 6 cause the numbers on each row to be different lenghts. For example, the number 1116 should be exactly the same lenght as 6666.
Hope this isn't to confusing.
Any reply would be great. "
That would be interesting to know
"This method works, but does not seem to automatically update every time the list changes.
How can you convert a list with duplicates into a list of unique entries that will update automatically every time the source list changes?"