You can get the count of unique items using the below formula..

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

If this post helps click Yes
---------------
Jacob Skaria


"frankfurtjoe" wrote:

How do i search a column of data which contains for instance multiple numbers
of headings, find each unique record item (ie apple , pear, orange) and then
display a list of each type (no duplicates) in a new range of cells. I will
then be able to use this record list as a means of providing a "record type
count" in a different worksheet. Thanks