Hi
how would I combine =iferror( ***insert array formula*** , "")
where my array formula is
=MEDIAN(IF($A$2:$A$12=$E2,IF($C$2:$C$12=F$1,$B$2:$B$12)))
Q
Hi
how would I combine =iferror( ***insert array formula*** , "")
where my array formula is
=MEDIAN(IF($A$2:$A$12=$E2,IF($C$2:$C$12=F$1,$B$2:$B$12)))
Q
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
That would become:
=IFERROR(MEDIAN(IF($A$2:$A$12=$E2,IF($C$2:$C$12=F$1,$B$2:$B$12))),"")
or you could write it as this:
=IFERROR(MEDIAN(IF(($A$2:$A$12=$E2)*($C$2:$C$12=F$1),$B$2:$B$12)),"")
where the * is equivalent to AND.
Whichever version you use, you must confirm the formula using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks