Calculating median with multiple part numbers that have mutliple unit prices
I have a list of part numbers which repeat when there are multple prices they were sold at.
For each unique part number I need one median price. 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.
This is a duplicate post. I answered in your other post in Functions forum.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
A sample workbook would be helpful.
Would the AVERAGEIF function work?
If the part numbers are in A2:A100, and prices in B2:200, could you the following in C2 and drag down:
Formula:
Please Login or Register to view this content.
Please click the * icon below if I have helped.
As ChemistB says, this is a duplicate post, please continue in the original here
This thread is closed
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks