finding the median from a list of unsorted numbers

G

Guest

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

Median of column I if column A numbers match 2
Median 3
Finding the median of numbers meeting criteria 3
How do I calculate the median of a distribution? 4
Median Question 4
More Median Questions 2
Sorting section numbers doesn't give correct order 3
Running tally comparing two columns in unsorted list 7

Top