You could always use a worksheet_change event macro to do this automatically
whenever appropriate cells change.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jay" wrote in message
...
I needed a summary that remained linked to the list, so that when the list
changed the summary changed too. Advanced filter doesn't do this. Thanks
for
the suggestion though

"Gord Dibben" wrote:

It has such a feature.

It is called DataFilterAdvanced Filter.

Unique Records Only


Gord Dibben MS Excel MVP

On Mon, 12 Nov 2007 18:47:00 -0800, jay
wrote:

Thanks for all your help guys. I found Niek's solution to be the
simplest.
Amazing that Excel doesn't provide a function to summarise a list of
text
considering all the other obscure stuff it can do.

Jay

"jay" wrote:

Hello, I have a column filled with a long list of text, with the same
entries
repeated several times, i.e.:

golf
soccer
soccer
golf
tennis
golf
biathlon

Is there a worksheet function that lets me specify a range of cells
and
returns a list of the text values that appeared in the range, i.e:

golf
soccer
tennis
biathlon


This seems like something a lot of people would want to do so I
imagine
there's a function for it, I haven't been able to find it though. Any
help
would be appreciated.

Thanks