Home >
OS > Statistical combined Excel multiple conditions to remove duplicate values
Statistical combined Excel multiple conditions to remove duplicate values
=ROUND (SUMPRODUCT ((C2: using C18=C2) * (E2: E18=E2) * (1/COUNTIF (B2: B18, B2: B18))), 0)
