Data=filter=Advanced filter, select copy to another location and click
the Uniques checkbox in the lower left corner.

This must be done each time you want the list. There is no built in
worksheet function that does this although you might be able to combine
several functions in a formula to achieve that result.

--
Regards,
Tom Ogilvy

"Jochem" wrote in message
om...
Hello,

I am looking for a function similar to the SQL function GROUP BY in
excel.

Basically what I want to do is make a list of all the unique variables
in a list. After that I want to use the COUNTIF function to make a
frequency table.

Thus from the list:
a
b
a
c
a
c

I want to get the list

a
b
c

Only the unique variables.

I am surprised that EXCEL doesn't have a pre-defined function for
this.

Anyone knows how to do it?

Jochem