On Tue, 18 Oct 2005 11:01:01 -0700, "Jeff"
wrote:

is there a function that would look at a range of cells and extract the
unique entries in the range and diplay them in a new "array" or column.

I would like to look at a column several hundered rows long and determine
what was entered in the column and how many times it was entered.

I know I could review the data and set up a column with the data I saw and
do a countif but I am looking for something a little cleaner that isn't
dependent on me to see every entry.

Thanks

Jeff


=UNIQUEVALUES(rng) will return the results in a single column.

This function is part of Longre's free morefunc.xll add-in, available at
http://xcell05.free.fr/


--ron