Hi
see your other posting in Excel.misc

-----Original Message-----
Hi,

Is there a way where I can get a list of distinct values
for a column
from a set of rows which is obtained by applying a set of
filter
parameters (basically equivalent of a select distinct in
SQL)?

I tried DCOUNT and it works to get the count of all
values matching
the filter parameters. But I couldn't seem to find a way
to get a
count of the distinct values in a column.

Please note that I need this to be done automatically,
i.e., if the
data changes, this count has to change. And the data that
I'm trying
to do a distinct is dynamic, i.e., it has to obtained by
applying a
set of filter conditions on the actual data in the
worksheet.

I'd appreciate any suggestions.

One way I could think of is write a formula which can
extract a subset
of rows from ny actual data into another range of cells
based on my
filter criteria. And then I can use FREQUENCY on this
subset. Is there
a function/formula which could extract a subset of rows
into another
range? (e.g., like SELECT in SQL.)

Thanks,
Kumar.
.