Count unique entries formula

  • Hi,


    I've a table(colA) with for example:


    A
    A
    B
    B
    1000
    2000
    C
    A
    B
    5000
    C
    C


    I would like a formule that counts every item onces without the duplicates.
    So every unique item should be counted, the result for the example above should be 6.


    Hope this is possible with a simple formule.


    Gr,


    Gollem

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!