Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Boblobla · 10-21-2010, 09:50 AM

Alright, here is what I need to do. I am not sure if Excel can do this but I need to do the following:

I have a column of purchase order numbers. Most of the numbers are unique but some are duplicates. Associated with these PO numbers is the status of an assignment. I need to determine how many unique PO numbers are associated with open assignments. I do not want excel to count the duplicates. Example below:

PO Number Status
A100 Open
A101 Closed
A101 Open
A200 Closed
A201 Open
A201 Open
A300 Closed
A400 Open

I need excel to report to me that Total Open POs = 4.

I don't know if there is a way to tally the total number of unique POs (i.e. not count the duplication of A101 and A201, tally each as one) and combine this with the use of the =countif() function.

Let me know if I need to provide any more info.

10-21-2010, 09:50 AM	#1
Boblobla Franchise Player Join Date: Apr 2008 Location: Calgary Exp:	Excel Formula Help Alright, here is what I need to do. I am not sure if Excel can do this but I need to do the following: I have a column of purchase order numbers. Most of the numbers are unique but some are duplicates. Associated with these PO numbers is the status of an assignment. I need to determine how many unique PO numbers are associated with open assignments. I do not want excel to count the duplicates. Example below: PO Number Status A100 Open A101 Closed A101 Open A200 Closed A201 Open A201 Open A300 Closed A400 Open I need excel to report to me that Total Open POs = 4. I don't know if there is a way to tally the total number of unique POs (i.e. not count the duplication of A101 and A201, tally each as one) and combine this with the use of the =countif() function. Let me know if I need to provide any more info.