Forum Discussion

diego9010's avatar
diego9010
Brass Contributor
Aug 08, 2023
Solved

Calculate the count without duplicates

I am looking for a formula to calculate the count without duplicates for unique combinations of "Country," "Code," and "Serial"    The result for country Mexico and Code 0014 should be 4 because it...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Aug 08, 2023

    diego9010 

    =MAP(A2:A10,B2:B10,LAMBDA(customer,code,COUNTA(UNIQUE(FILTER(C2:C10,(A2:A10=customer)*(B2:B10=code))))))

     

    You are welcome. This formula is a little bit shorter.

     

    Unfortunately i don't know how we can do this with SUMPRODUCT and COUNTIFS and without LAMBDA, UNIQUE functions.

     

     

Resources