Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 02-15-2012, 03:27 PM
BrazzellMarketing BrazzellMarketing is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
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, 12 views)
Reply With Quote
  #2  
Old 02-16-2012, 12:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows XP Office 2003
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,366
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi

I opened your sheet and both formulas work perfectly.
What error do you get?
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 02-16-2012, 09:19 AM
BrazzellMarketing BrazzellMarketing is offline Windows 7 64bit Office 2010 64bit
Competent Performer
 
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 Windows 7 32bit Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 356
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 Windows 7 64bit Office 2010 64bit
Competent Performer
 
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
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


All times are GMT -7. The time now is 01:02 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft