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
767
you can use COUNTIF function

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!