I am trying to find out how to get a sum of unique values for a column of entries that contains duplicate values. In Column A I have a list of Parts Libraries and in Colum B I have a list of Part Numbers. I need two things from this list - a sum of parts for each unique library (which I can achieve with a Pivot table) but I also need a sum of "unique" part numbers for each library. How do I get this value?See screen shot - I entered the Unique Part Numbers column manually to show what information I need help in getting. Thank you in advance for any help!


3-20-2014 5-07-49 PM.png