Hi,
how to write the formula for Countif with multiple criteria and duplicates counted once.
I want the number of client seen by E name as a criteria funded by. if E name seen the client multiple times a day then it should consider as a one client count.
I attached the sample table and answer...