Filtering a Range into a List of Unique Records

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.

image 1


Follow the steps given below:

  • Select the cell
  • Go to Data tab > Sort & Filter group > Click on Advanced
  • Advanced Filter dialog box will appear
  • Click on Filter the list, in place
  • Select list range (Agent Name), on the basis of which we want to return the unique value
  • Then check mark on Unique records only

image 2


  • Click OK
  • Now only unique list will appear

image 3


How to clear the filter?

Follow the steps given below:

  • Go to Data Tab
  • In Sort & Filter group > Click on Clear

image 4


image 5


And, in this way we can put the filter for unique records in Microsoft Excel.
image 48


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


  1. "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. "

  2. "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?"

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.