Median Formula Help
Hi:
In the attached I am trying to calculate the mean by the second column "Criteria Change Number"
I have a large scale of data I am trying to calculate... for example if the criteria number is 1 then return the median for that group and so on.
I am able to go through individually but not sure on the larger scale of data.
Thanks
try the array entered median if something like
Formula:
Please Login or Register to view this content.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Didn't quite obtain the results I was looking for.
Can you paste your copy of the formula with my spreadsheet?
Criteria 1 was has a median of 14.208. I am trying to show that in all cells with Criteria 1... and then down the entire list for all criteria.
Last edited by johnsor1; 06-15-2016 at 11:50 PM.
can't upload right now..
range is up to 800 you can change this.
in C2 -> confirm with ctrl + shift + enter the formula below then drag down.
=MEDIAN(IF($B$2:$B$800=B2,$A$2:$A$800))
Last edited by vlady; 06-15-2016 at 11:55 PM.
Here's the workbook with vlady's formula.
Dave
Thanks Dave.
You're welcome. Glad I could help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks