Forum Discussion
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...
=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.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.