Hints and tips home » Excel hints and tips » Create a unique items table from a duplicating table

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

Added by Orok on 23rd November 2006

More Excel hints and tips, like:

• Finding your worksheets quickly
• Colouring cells containing formulas
• Highlighting a data range