Previous Topic Next Topic

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

Closed
Piggy70 Posts 3 Registration date Wednesday May 29, 2013 Status Member Last seen May 30, 2013 - May 30, 2013 at 11:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 1, 2013 at 06:22 PM
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


Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 1, 2013 at 06:22 PM
you can use COUNTIF function
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Excel - To generate unique ID
wliang -
ferg -

4 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses