have a tough one he

I have a report that shows shipped orders (column A) and the carrier
used for that order (column B). Since the order number in Column A is
repeated for every item shipped, Column A is not reliable for unique
order numbers. Also different orders have different carriers in Column
B.

What I am needing is for every match of a certain carrier (column B) to
pull back unique order numbers in Column A.


Here is a visual example if a better explination is needed:

Order Carrier
1 UPS
1 UPS
2 FedEx
3 UPS
3 UPS
3 UPS
4 UPS
4 UPS
5 FedEx

From the list above, if I wanted to know how many unique orders shipped
UPS is there a formula that exists to give me this information?


--
alehm
------------------------------------------------------------------------
alehm's Profile: http://www.excelforum.com/member.php...o&userid=27077
View this thread: http://www.excelforum.com/showthread...hreadid=465946