Posted to microsoft.public.excel.newusers

Bad_Shot

external usenet poster

Posts: 1

Finding the Median

I need to determine the Median of one column, while selecting those rows in a
specific date range.

I need the Median of Col 5, using a date range of Col 2.

Sample Data
Sold 1/10/2008 188 6900000 188 6300000
Sold 1/14/2008 44 575000 135 556200
Sold 1/28/2008 181 349900 335000
Sold 1/31/2008 98 775000 292 757000
Sold 2/1/2008 7 319900 7 315000
Sold 2/8/2008 136 849000 136 750000

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Median	reno	Excel Discussion (Misc queries)	3	August 21st 07 08:12 PM
finding the median from a list of unsorted numbers	Christopher Buxton	Excel Discussion (Misc queries)	2	March 21st 07 12:53 PM
Max/Min/Median	gibsol	Excel Worksheet Functions	3	February 28th 07 03:22 PM
Finding the median of numbers meeting criteria	thekovinc	Excel Discussion (Misc queries)	3	February 7th 06 12:45 AM
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 02:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us