Hi Everone,
I have following formula in E2
=COUNTIFS($A$2:$A2,A2,$B$2:$B2,B2,$D$2:$D2,D2,$C$2:$C2,C2)
and its giving me following output. I need to count unique customers in given criteria. Right Most column is my desired output.
<colgroup><col><col><col><col><col><col></colgroup><tbody>...