Hey guys, new here. Visited a lot, but just joined and this is my first post.
I'm using this formula in several columns of a cross-tab, and it seems to be working in most, but not a couple.
So this works: {=MEDIAN(IF(working!O:O>3,working!E:E))}
Yet this doesn't: {=MEDIAN(IF(working!O:O<4,working!E:E))}
And yes, there are results that meet that IF requirement. Workbook is attached. Help is appreciated.
take just
{=MEDIAN(IF(O:O<4,E:E))} this will probably always return 0 as blanks are counted as 0
try
{=MEDIAN(IF(O:O<4,IF(E:E<>"",E:E)))}
buy try and avoid whole range references limit to what you are likely to need
say e1:e2000
Last edited by martindwilson; 02-28-2014 at 07:55 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Awesome, that works, thank you very much.
Hi happycynic80
Another version and a non array as you are using Excel 2010.
Formula:
Please Login or Register to view this content.
Last edited by Crisp Packet; 03-02-2014 at 04:56 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks