Re: Finding the Median

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I presume you mean by the fifth column the one that starts off with 188, 135. If so, you appear to be missing the value for this column in the third row. Did you accidentally leave out the value? Is it really supposed to be an empty cell? Should it have been a 0? If it was deliberately left out, should it be treated as a 0 or should it be ignored completely?

--
Rick (MVP - Excel)


"Bad_Shot" <Bad_Shot@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F064F6D2-F01F-4CB3-B2EF-6826832026D2@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: creating sequential rows
    ... The code works perfectly with the sample data you posted and it produces a ... Your quote: "Actually, if it would be easier, I can also fix the range to ... "What I need is a loop that goes through and will insert rows ... Inserts lines plus the missing number. ...
    (microsoft.public.excel.programming)
  • Re: Some lorry drivers want their heads testing:
    ... So the driver should be monitoring traffic movements in his vicinity ... and presume that anything that has gone missing is in his blind spot. ...
    (uk.rec.driving)
  • Re: Anxiety
    ... to replace the last of the metal tags here (ireland) with ... Two missing is a problem, I presume of different breeds ...
    (uk.business.agriculture)
  • Re: descrete Convolution
    ... and I also assumed that for the missing ... % Let's make it zero at the missing locations. ... but as far as I can tell it's not convolution, ...
    (comp.soft-sys.matlab)
  • Re: Where is the error?
    ... You're missing a closing bracket for the body of mean, ... definition of median(). ... Your compiler is trying to tell you that you ...
    (comp.lang.c)