Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |