View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Count Unique Values

Is there a formula that will count the number of unique values based on a
crriteria? For example. I have a sheet of part numbers with coresponding
purchase order number and quantity received. For a number of part numbers
there are multiple receipts on a purchase order so the PO number shows up
multiple times. I want to count the number of PO's base on the Part number.
How can I do that?