Median Function Help

[couger77]

Please Login or Register  to view this content.

Thanks for your help all!

Jeremy

[oldchippy]

Try this in Sheet1 cell B2

=MEDIAN(IF(Sheet2!$A$2:$A$9=A2,Sheet2!$B$2:$B$9)) enter as an array, Ctrl+Shift+Enter and copy down

[couger77]

It appears to be working for that sample. However, when I apply it to my actual file, it does not work. It gives a #N/A if the column is longer than the values ie: $B$2:$B$100. Basically if there is no data it errors.

Does that make sense?

[oldchippy]

Try this,

=MEDIAN(IF(Sheet2!$A$2:$A$9=A3,IF(Sheet2!$A$2:$B$9<>"",Sheet2!$B$2:$B$9)))

[couger77]

Try this,

=MEDIAN(IF(Sheet2!$A$2:$A$9=A3,IF(Sheet2!$A$2:$B$9<>"",Sheet2!$B$2:$B$9)))

Hey I think that worked! Thank you very much for lending your expertise.

Couger77

[oldchippy]

Only trying to help - thanks for the feedback