Advanced Filter will not work in my case because my range covers several
columns (not just rows).

Pete_UK wrote:
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

I've tried Advanced Filter several different ways and have not been able to
get it to work.
[quoted text clipped - 14 lines]

- Show quoted text -