Counting unique rows

  • For over 30'000 rows, the calculation engine will get stuck ...


    A shortcut would be to use VBA for the evaluation


    Code
    1. Sub TestUnique()
    2. MsgBox Evaluate("=SUMPRODUCT(((1/COUNTIF(A1:A34538,A1:A34538)*(B1:B34538=G2))))")
    3. End Sub

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)

  • You're welcome.


    Quote


    and you are looking for a result that will give counts of each unique colour/number combinations. Is that correct?

    By that I meant did you want the counts for every colour, and you replied "Yes" :)

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • For over 30'000 rows, the calculation engine will get stuck ...


    A shortcut would be to use VBA for the evaluation


    Code
    1. Sub TestUnique()
    2. MsgBox Evaluate("=SUMPRODUCT(((1/COUNTIF(A1:A34538,A1:A34538)*(B1:B34538=G2))))")
    3. End Sub

    That also works well thank you