Forum Discussion
Solved
How do I find the median of a selected column of values within a worksheet
I have a worksheet that has a column of ID names. There are various numbers of line items with the same ID names. I need to find the median of all values that share an ID name. I know this should b...
Is it possible for you to upload a sample (devoid of actual names or other confidential info)? Otherwise, all you'll get is very general and it sounds very much like you would appreciate specific help.
You are my hero. I'd never be able to reproduce it, but I did plug the formulas into my actual spreadsheet, and it worked. Yippee! I'm gonna look like a genius!
lodonnellma you're very welcome. The aggregate function lets you do some array calculation while ignoring errors (the errors being when the look up in A isn't the same as this row and the false becomes 0 and it is dividing by 0). I use it 2x for the 'largest' n/2 value and round up and down so if there is an even number it takes avg of those middle 2, otherwise it takes avg of the same middle number.
as for conditional formatting it is relatively straight forward
but sure feel free to ask questions 🙂