Take a look at Debra Dalgleish's site he

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

She shows how you can use Advanced Filter to get a list of unique
values.

Hope this helps.

Pete

On Sep 16, 7:45*pm, "golddave" <u54833@uwe wrote:
I've tried Advanced Filter several different ways and have not been able to
get it to work.



Luke M wrote:
You can use Data - Filter - Advanced Filer to copy unique values. Note that
you will need to use a named range in order to copy from one sheet to
another. Once copied, simply sort the data.

If you wish this to be automated, I would recommend recording a macro of the
previous actions. You could then either link this to a command button, or a
worksheet_event, depending on your needs.
I have a spreadsheet where Sheet A contains names (including duplicates) in a
range. *I'd like Sheet 2 to list the distinct names in alphabetical order.
Any ideas?

Thanks,
Dave- Hide quoted text -

- Show quoted text -