Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2012, 03:27 PM
BrazzellMarketing BrazzellMarketing is offline Excel Not Finding the Median Windows 7 64bit Excel Not Finding the Median Office 2010 64bit
Competent Performer
Excel Not Finding the Median
 
Join Date: Apr 2010
Location: Galax, VA
Posts: 120
BrazzellMarketing is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Test.xlsx (8.9 KB, 18 views)
Reply With Quote
  #2  
Old 02-16-2012, 12:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Excel Not Finding the Median Windows XP Excel Not Finding the Median Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 02-16-2012, 09:19 AM
BrazzellMarketing BrazzellMarketing is offline Excel Not Finding the Median Windows 7 64bit Excel Not Finding the Median Office 2010 64bit
Competent Performer
Excel Not Finding the Median
 
Join Date: Apr 2010
Location: Galax, VA
Posts: 120
BrazzellMarketing is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 02-17-2012, 01:31 PM
zyzzyva57 zyzzyva57 is offline Excel Not Finding the Median Windows 7 32bit Excel Not Finding the Median Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

I think you have your Function stated wrong:

=MEDIAN(C1,C8)

Try this:

=MEDIAN(C1
:C8)

Colon, NOT comma
Reply With Quote
  #5  
Old 02-17-2012, 02:20 PM
BrazzellMarketing BrazzellMarketing is offline Excel Not Finding the Median Windows 7 64bit Excel Not Finding the Median Office 2010 64bit
Competent Performer
Excel Not Finding the Median
 
Join Date: Apr 2010
Location: Galax, VA
Posts: 120
BrazzellMarketing is on a distinguished road
Default

That's it. Thank you. I was stating the formula incorrectly for my intended result.

How do I mark the thread as solved?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Not Finding the Median 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
Excel Not Finding the Median 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft