just the list shown in filter

Ron · Oct 21, 2004

In Excel 2003 - I have large lists with repeat entries in some fields. Is
there a way to extract just the unique list that is shown in the filter?

Debra Dalgleish · Oct 21, 2004

You can use an Advanced Filter to extract the unique records. There are
instructions in Excel's Help, and here:

http://www.contextures.com/xladvfilter01.html