finding the median from a list of unsorted numbers

C

Christopher Buxton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Median of column I if column A numbers match 2
Help in Median of a quartile 4
Finding the proper style field and the numbered paragraph value within the style 0
Median 3
Finding the right style field in VBA 0
How do I calculate the median of a distribution? 4
Finding the median of numbers meeting criteria 3

Top