#1
|
|||
|
|||
Excel Not Finding the Median
Can someone please tell me why this spread sheet can't find median? Column A has cells copied from a larger spreadsheet where the Median function is not working. Column C has values I just typed in fresh, and the Median function is working fine. I'm guessing there's something embedded in these cells that makes the Median function not work, but I can't find it.
I've tried the copy and paste value feature to try to eliminate whatever is in these cells, but no luck. |
#2
|
||||
|
||||
Hi
I opened your sheet and both formulas work perfectly. What error do you get?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
On my machine the formula in column A returns everything but the Median. As I uploaded it, the formula in Column A returns a value of 87. Last night, when I sorted the data from smallest to largest, the value changed (which shouldn't happen with a Median function). Today, I cannot reproduce that particular error, but the Median for column A should be 21, not 87. Now I'm noticing that if I change the last value in column C to 10, the Median formula result changes to 6. My understanding of Median is that, if you have an odd number of numbers, Median is just the number in the middle when you sort them by highest to lowest. Changing the largest number to a larger number, shouldn't affect Median, by my understanding.
Thanks for looking at it. I'm hoping the hive mind can help. |
#4
|
|||
|
|||
I think you have your Function stated wrong:
=MEDIAN(C1,C8) Try this: =MEDIAN(C1:C8) Colon, NOT comma |
#5
|
|||
|
|||
That's it. Thank you. I was stating the formula incorrectly for my intended result.
How do I mark the thread as solved? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Finding a problem font | RickRS | Word | 5 | 10-14-2011 05:35 PM |
Help finding starting point on project (Excel/Access?) | ndk415 | Office | 1 | 06-19-2011 03:28 AM |
Finding Corrupt Files | rockstar | Office | 1 | 02-25-2011 01:55 AM |
finding paragraphs | sixhobbits | Word | 2 | 06-14-2010 09:48 AM |
finding contacts quickly | Jackdeanperry | Outlook | 0 | 12-21-2009 11:28 AM |