Hello,
Please see attached.
I want to view the MEDIAN when filtering the data by any selected field.
I can create a subtotal formula for (Total) & (Average) so it will change whenver I filter the data byany field. But how make MEDIAN figures move/change with the selected criteria?
Plz HELLLLLLPPPPP. Thanks
Hi,
I think you can achieve the result you're after like this:
=MEDIAN(IF(SUBTOTAL(3,OFFSET(E5:E13,ROW(E5:E13)-MIN(ROW(E5:E13)),,1)),E5:E13,""))
entered using CTRL, SHIFT and ENTER to confirm it as an array function. Excel will display it like this....
{=MEDIAN(IF(SUBTOTAL(3,OFFSET(E5:E13,ROW(E5:E13)-MIN(ROW(E5:E13)),,1)),E5:E13,""))}
if done correctly
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks