count unique and same with reference to its value

[sanjyou]

I need to find count for unique and for same multiple value

( ram task Assigned To same type of Names e.g hari=2 times and sanju= 3 times ) result =5

( ram task Assigned to different type of Names e.g anu=1 times,raju= 1 times,shyam = 1 times )=3

please help !!!!!!!!!

 

[sanjyou]

not working sorry for wrong forum post!!!!!!

 

[Fluff]

not working

Could you supply a little more information?

 

[sanjyou]

sample5.xlsx

raw data Task,assigned ram,hari ram,hari ram,sanju ram,sanju ram,sanju ram,Anu ram,raju ram,shyam

docs.google.com

 

[sanjyou]

i have share google sheets link ...

 

[Fluff]

Where is the formula?

 

[sanjyou]

Where is the formula?

tried but not working?can you please update formula on same sheet i share with you ..i had provide edit access in it..

 

[Fluff]

"Not working" is less than helpful. What happened when you put the formula in?

 

[sanjyou]

wrong result ...

 

[sanjyou]

wrong result ...

Right result should be 5 & 3 repectively

 

[Fluff]

Did you change the formula to include the sheet name in the range references?