Excel: Unique count of values in one column conditional 2nd colu

Closed
Report
Posts
3
Registration date
Wednesday May 29, 2013
Status
Member
Last seen
May 30, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

Column A Column B:
WEST-WARD,INC. 00015
WEST-WARD,INC. 00015
HOSPIRA 00016
ROXANE LABS. 00017
GLOBAL PHARM 00018
GLOBAL PHARM 00018
WEST-WARD,INC. 00018
WEST-WARD,INC. 00018
WEST-WARD,INC. 00018
LANNETT CO. INC 00018
LANNETT CO. INC 00018
MAJOR PHARMACEU 00018
GLOBAL PHARM 00019
GLOBAL PHARM 00019
WEST-WARD,INC. 00019
WEST-WARD,INC. 00019
WEST-WARD,INC. 00019
LANNETT CO. INC 00019
LANNETT CO. INC 00019


In the above Column A and Column B I am trying to get a unique count of all of the names in Column A, conditional upon the value/change in Column B
For example:
00015 - the unique value should be '1' as only 'West-ward,Inc' is associated with 00015
00018 - the unique value that i want to be returned should be '4' as Global, West-Wars , Lannett and Major' are associated with 00018.....I have tried in vain to get this formula but have had no success. Any help is highly appreciated


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use COUNTIF function