Jump to content

Create a Unique List


Recommended Posts

Create a Unique List

The Advanced Filter can quickly create a unique list of items when a list contains duplicates. If you remember to click the Unique Records Only option. To create a

unique list, select the original list with duplicates and the heading cell. (The list must have a label heading.

For instance, you might head a list of states with the label "States.") Choose Data, Filter, Advanced Filter. Then, click the Copy To Another Location option. Select the Unique Records Only option. Note the target range or cell in the Copy To control box. Click OK. The resulting list will contain only one entry for each unique item in the original list.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...