MEDIAN

[gronkette1]

I need to compute the MEDIAN value for the following list, but I must ignore the blanks and FALSE (it skews the result).

thank you !


$28.95
$28.00
$-
$28.44
$27.40
$27.92
$28.44
$27.92
$-
$-
$26.88
$-
$27.92
$-
$27.50
FALSE
$-
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE
FALSE

 

[Yogi Anand]

Hi Yogi,

Did you copy the data from the post? If so, you have the $- (blanks in the OP's terms) being treated as text, which is ignored with the MEDIAN function. That is why the problem is the zero values and not the FALSE cells.

Change the $- to zero and you should get 27.45.

Regards,
Jay

Hi Jay:
Ya! you are right Jay ... I had copied and pasted from the board!
This message was edited by Yogi Anand on 2002-04-11 10:53

 

[Aladin Akyurek]

On 2002-04-11 10:35, gronkette1 wrote:
You guys are the greatest!!!

I used {=MEDIAN(IFL4:L41<>0,L4:L41))}

and it returned $27.92

thank you, thank you!

Now try:

=MEDIAN(IF(L4:L41,L4:L41))

array-entered.

If it gives you #VALUE!, then you have blanks in L4:L41 which are generated by a formula.

If you change that formula to return 0 instead of "", the above formula will you the desired result.

Aladin