+ Reply to Thread
Results 1 to 2 of 2

Count unique text

  1. #1
    shzdug
    Guest

    Count unique text

    Is there a function, or good way,to count unique text in a list? For
    example, I would like an answer of 3 from the text in the list below:

    Dog
    Cat
    Dog
    Bird

    Thanks!

  2. #2
    David Billigmeier
    Guest

    RE: Count unique text

    Assume your range is A1:A10:

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

    --
    Regards,
    Dave


    "shzdug" wrote:

    > Is there a function, or good way,to count unique text in a list? For
    > example, I would like an answer of 3 from the text in the list below:
    >
    > Dog
    > Cat
    > Dog
    > Bird
    >
    > Thanks!


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1