I have a list of part numbers some of which repeat when there are multple prices they were sold at.
I need to calculate the median for these part numbers' prices everytime the part number changes.
The list if of about 500 parts but with the various different prices the file is 3700 rows. How can i
do this quickly? For each unique part number I need one median price.
Bookmarks