» Filtering a Range into a List of Unique Records

CATEGORY - Excel Filter VERSION - All Microsoft Excel Versions

To filter a range into a List of unique records:

1. Select a cell the range (see screenshot).
2. From the Data menu, select Filter, and then Advanced Filter.
3. Select Copy to another location.
4. In the Copy to box, insert a cell address.
5. Select the Unique records only checkbox, and then click OK.
Screenshot // Filtering a Range into a List of Unique Records

Filtering a Range into a List of Unique Records

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 3.22 Views: 72651

Does not automatically update

Ken Brucker Posted on: 31-12-1969

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?

reply curious

Anders Posted on: 31-12-1969

That would be interesting to know

Number Alignment in Excel 2000

David Fabricant Posted on: 31-12-1969

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.