locked
CountRow+Earlier=Count Unique Value RRS feed

  • Question

  • I don't get why below code returns unique count (row).  Thanks

    =COUNTROWS(FILTER('Table1','Table1'[Value]>EARLIER('Table1'[Value])))+1

    Item Value Rank

    A       100     1
    B       50     6
    C       50     6
    D       60     4
    E       80     3
    F       100     1
    G       60     4

    Friday, October 28, 2016 1:35 AM

Answers