Use advanced filters, select the list range (include a header), choose the
Copy to another Location (must be on same sheet) and check the Unique
Records only.

Signature
Regards,
Nigel
nigelnospam@9sw.co.uk
>I have a spreadsheet with codes, number codes not programming, that need to
> be pulled to a summary table. I was wondering if there was a way of
[quoted text clipped - 6 lines]
> 05, 08, 10, 10. The summary table will automatically show 02, 04, 05, 08,
> 10.
Shawn777 - 28 Jan 2008 20:53 GMT
Thank you. That wasn't how I pictured this solution, but I can make this
work - and it is a fairly easy fix.
> Use advanced filters, select the list range (include a header), choose the
> Copy to another Location (must be on same sheet) and check the Unique
[quoted text clipped - 10 lines]
> > 05, 08, 10, 10. The summary table will automatically show 02, 04, 05, 08,
> > 10.