Unique count

[vmjan02]

I have this table what is required if the column Apr'23 cell is blank then no action but if has value then it to do a unique client count for column Actual Client Name output in column A.

Is their is a way as i tried a to but no desired result.

C count - Desired (Actual Client Name as Ref)	Actual Client Name	Apr'23
1​	Bank of Maharashtra	0
2​	Bank of Maharashtra	1
1​	DIPG (Goa)	1
1​	Nudge AWC FOUNDATION	1
2​	Nudge AWC FOUNDATION	1
1​	Adani Estate Management	1
1​	ECGC	1
1​	Sanofi	1
1​	Symbiosis Inst of Law Management	1
1​	APV- Citadel	1
1​	Directorate of information (G-20/Gujarat)	1
	Nucleus Office Parks
3​	Bank of Maharashtra	2
1​	Dezerv	2
2​	Dezerv	2
	ABC MF
	Adani Estate Management
	Aegon Life Insurance
	AMFI

 

[Fluff]

It works for me

Fluff.xlsm
	A	B	C
1	Uniq CC RO IN	Actual Cleint Name	Apr'23
2		CG Govt
3		CG Govt
4		CG Govt
5	1	CG Govt	4
6	2	CG Govt	4
Master

Cell Formulas
Range	Formula
A2:A6	A2	=IF(C2<>"",COUNTIFS(B$2:B2,B2,C$2:C2,"<>"),"")

Can you post some data using the XL2BB add-in that shows the problem

 

[vmjan02]

=IF(C2<>"",COUNTIFS(B$2:B2,B2,C$2:C2,"<>"),"")

I am using the same function but i am not getting the same result, not sure why.

Uniq CC RO IN (Col BA)	Actual Cleint Name (Col BB)	Apr'23 (Col BC)
	Nucleus Office Parks
	Nucleus Office Parks
3 (its not giving 1)	Nucleus Office Parks	3
4 (its not giving 2)	Nucleus Office Parks	1
	Nucleus Office Parks
	Nucleus Office Parks

my record starts from row number 8.

=IF(BC8<>"",COUNTIFS(BB$8:BB8,BB8,BC$8:BC8,"<>"),"")

 

[Fluff]

That suggest that col BC is not blank, is there a formula in it & if so what?

 

[vmjan02]

That suggest that col BC is not blank, is there a formula in it & if so what?

yes it has a formula

=IF(AI8="","",INDEX(F8:AT8,MATCH($BC$7,$F$7:$AT$7,0))/100000)

this is the formula in BC

 

[Fluff]

Ok, try

=IF(BC8<>"",COUNTIFS(BB$8:BB8,BB8,BC$8:BC8,">0"),"")

 

[vmjan02]

=IF(BC8<>"",COUNTIFS(BB$8:BB8,BB8,BC$8:BC8,">0"),"")

perfect this is correct.

 

[Fluff]

You're welcome & thanks for the feedback.