No, you don't need to specify a criteria range. You can extract unique
values from the entire list.

KG wrote:
When using Excel's Advanced Filtering utility to copy unique records to a
different location, does one need to specify a criteria range or is the
selection "unique records only" self evident?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html