View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Bad_Shot Bad_Shot is offline
external usenet poster
 
Posts: 1
Default 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