Hi, I am trying to figure out how to find the average of a list of prices that include duplicates. I do not want to include the duplicates. For example - I have a list of part numbers, each part number has several prices. Some are the same and some are different. I want to average the ones that are different.
PartNumber Price
00011 .50
00011 .50
0125 .10
00011 .51
0125 .20
0125 .10
What I need to do is average part number 00011 using .50 and .51 ( divided by 2 NOT 3 because .50 is a duplicate). Does that make sense?
Of course my data is much larger but thats the concept.
Any help would be greatly appreciated.
Bookmarks