Can you create a list of unique items, and enter them in a column?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Ralph" wrote in message
...
i cant seem to get these formulas to work, but i'm very excited that i think
there may be a solution here, is it possible that i could email the file to
you and you could show me how to arrange those formulas??? or can I post the
file somehow to this discussion group??


"RagDyeR" wrote:

Maybe not exactly what you're looking for, but ...

You could enter this formula in the column adjacent to the datalist, which
will simply display the count of every item in the table:

=COUNTIF($A$1:$A$100,A1)

And copy down.

Then, this formula will give you a count of the unique items in the table:

=SUMPRODUCT((A1:A100<"")/COUNTIF(A1:A100,A1:A100&""))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Ralph" wrote in message
...
Hi,

Is there a way to select a table and have excel produce a list ranking the
#
of times each item shows up in the list, i.e.

dog 5
cat 2
bird 1
???

Thanks