In my attached workbook I have a data from that I just want to calculate the Unique name count
1) how many Analyst processing “ENG “ as “Process, when “Successful/Rejected”=” Successful”, “Start/Close”=”Closed”,” Region”=”JAPAC”.
2) how many Analyst processing “Indirect “ as “Process, when “Successful/Rejected”=” Successful”, “Start/Close”=”Closed”,” Region”=”AMER”.
The only problem what I am facing here is it’s calculate the total number of Analyst but I want the unique name count,
if you go through the attachment you can fined for each name different deal ID will be there, if you filter out as I mention,it will reflect deal ID as 9,18,34,43, under "DIN name
I have putted my formula in H10 and K10.in both the scenario the result is reflecting as 4 (count of all name) but the correct one will be 1 as the same name is reflecting as 4 times.
Can any one help me out in this by any formula?
Regards
Arindam
Bookmarks