Home 
Search 
Today's Posts 
#1




finding the median from a list of unsorted numbers
My data has a column of numbers which are unsorted. The data is updated on a
regular basis so physically sorting in ascending order is not possible. I need excel to some how automatically sort the numbers into ascending order, count the total number of numbers and find the median value. if the total number of values is an even number i need it to add the middle two values and divide by 2 inorder to find the median. Is this possible? If so how would you go about doing it as I'm really stuck with this. Any help would be greatly appreciated. Thanks Chris 
#2




finding the median from a list of unsorted numbers
How about =median(a1:a100) ?
"Christopher Buxton" wrote: My data has a column of numbers which are unsorted. The data is updated on a regular basis so physically sorting in ascending order is not possible. I need excel to some how automatically sort the numbers into ascending order, count the total number of numbers and find the median value. if the total number of values is an even number i need it to add the middle two values and divide by 2 inorder to find the median. Is this possible? If so how would you go about doing it as I'm really stuck with this. Any help would be greatly appreciated. Thanks Chris 
#3




finding the median from a list of unsorted numbers
Why not =MEDIAN(A1:A99) ?
 David Biddulph "Christopher Buxton" wrote in message ... My data has a column of numbers which are unsorted. The data is updated on a regular basis so physically sorting in ascending order is not possible. I need excel to some how automatically sort the numbers into ascending order, count the total number of numbers and find the median value. if the total number of values is an even number i need it to add the middle two values and divide by 2 inorder to find the median. Is this possible? If so how would you go about doing it as I'm really stuck with this. Any help would be greatly appreciated. Thanks Chris 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Finding a predetermined Sum from a List of Numbers  Excel Discussion (Misc queries)  
Finding the median of numbers meeting criteria  Excel Discussion (Misc queries)  
lookup unsorted list  Excel Discussion (Misc queries)  
An unsorted list in vlookup  Excel Worksheet Functions  
Finding Median if a value = 1.. help!  Excel Worksheet Functions 