Hi
From a list of purchase order data, I want to determine 2 things:
1 Number of unique suppliers with open purchase order quantities due in a specified week, and how many of them have outstanding PO's
2 Number of unique suppliers from beginning of list right up to end of specified week, and how many of these still have outstanding PO's. So 1 is a subset of 2
The attached excerpt better illustrates what I want and the correct answers I'm looking for. I'm fairly confident in Excel and have used SUM/IF/FREQUENCY/MATCH combinations as an array before but this has me stumped! I'm open to as many helper columns as needed. I could write a little VBA routine but would rather have a non-VBA solution.
Regards
Alan
Bookmarks