Excel formula to count Unique Values

[vinmam123VBA]

Hi All,

Can someone please help with below requirements:

Raw Data is like below:

Name	Project
Chennai	Project A
Chennai	Project A
Delhi	Project B
Mumbai	Project C
Mumbai	Project C
Mumbai	Project D
Chennai	Project A
Mumbai	Project E
Chennai	Project F

Would Like to see the Unique Project numbers in each city and Out put should be like Below

Would be great If someone help with formula to pull unique project numbers(Highlighted in Orange)

Regards,
Vinmam

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C						I	J	K
1	Name	Project
2	Chennai	Project A								Chennai	2
3	Chennai	Project A								Delhi	1
4	Delhi	Project B								Mumbai	3
5	Mumbai	Project C
6	Mumbai	Project C
7	Mumbai	Project D
8	Chennai	Project A
9	Mumbai	Project E
10	Chennai	Project F
11
12
13
Data

Cell Formulas
Range	Formula
K2:K4	K2	=SUM(--(FREQUENCY(IF($A$2:$A$100=J2,MATCH($B$2:$B$100,$B$2:$B$100,0)),ROW($A$2:$A$100)-ROW($A$2)+1)>0))
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[vinmam123VBA]

How about

+Fluff 1.xlsm
	A	B	C						I	J	K
1	Name	Project
2	Chennai	Project A								Chennai	2
3	Chennai	Project A								Delhi	1
4	Delhi	Project B								Mumbai	3
5	Mumbai	Project C
6	Mumbai	Project C
7	Mumbai	Project D
8	Chennai	Project A
9	Mumbai	Project E
10	Chennai	Project F
11
12
13
Data

Cell Formulas
Range	Formula
K2:K4	K2	=SUM(--(FREQUENCY(IF($A$2:$A$100=J2,MATCH($B$2:$B$100,$B$2:$B$100,0)),ROW($A$2:$A$100)-ROW($A$2)+1)>0))
Press CTRL+SHIFT+ENTER to enter array formulas.

This is Awesome!! Thanks fluff!

 

[Fluff]

You're welcome & thanks for the feedback.