If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 finding the median from a list of unsorted numbers
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## finding the median from a list of unsorted numbers

#1
March 21st 07, 12:40 PM posted to microsoft.public.excel.misc
 Christopher Buxton external usenet poster Posts: 7
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
March 21st 07, 12:53 PM posted to microsoft.public.excel.misc
 bpeltzer external usenet poster Posts: 171
finding the median from a list of unsorted numbers

"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
March 21st 07, 12:53 PM posted to microsoft.public.excel.misc
 David Biddulph[_2_] external usenet poster Posts: 8,651
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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Finding a predetermined Sum from a List of Numbers [email protected] Excel Discussion (Misc queries) 5 January 17th 07 12:11 AM Finding the median of numbers meeting criteria thekovinc Excel Discussion (Misc queries) 3 February 7th 06 12:45 AM lookup unsorted list sslenterprises Excel Discussion (Misc queries) 2 October 25th 05 09:24 AM An unsorted list in vlookup Traima Excel Worksheet Functions 2 August 8th 05 01:10 PM Finding Median if a value = 1.. help! Greg Excel Worksheet Functions 2 February 13th 05 03:28 AM

All times are GMT +1. The time now is 08:44 PM.