count unique customer

[sambit]

Sir,

Please help to resolve the below issue.

Shop no has multiple customer. What is the formula for Unique customer in column c.

Shop No​	customer​	No of Customer (Count)​
23623​	A​	​
23623​	A​	​
23623​	A​	​
23623​	B​	​
23623​	B​	​
23674​	C​	​
23674​	C​	​
23674​	C​	​
23674​	C​	​
23674​	C​	​
23677​	D​	​
23677​	E​	​

Result given below

2​

2​

2​

2​

2​

1​

1​

1​

1​

1​

2​

2​

 

[Rakesh1610234]

Please refer the attached file.

 

[Monty]

Hey Smabit
Try this

=COUNTIFS($B$2:$B$13, B2, $A$2:$A$13, A2)

Drag this formula down for the entire column C. This formula counts the unique customers for each shop number.

 

[Debaser]

Hey Smabit
Try this

=COUNTIFS($B$2:$B$13, B2, $A$2:$A$13, A2)

Drag this formula down for the entire column C. This formula counts the unique customers for each shop number.

No it doesn't. It counts the number of times a specific customer appears for a specific shop.

 

[vletm]

sambit​

With 'older' Excel, You could use something like this... F & G-columns.

 

[sambit]

sambit​

With 'older' Excel, You could use something like this... F & G-columns.

vletm sir,
Thank you very much.