Hi all, anyone know a formula they may work as a conditional median?
MQ
Hi all, anyone know a formula they may work as a conditional median?
MQ
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
You mean like a {MEDIAN(IF)} array construction?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Perhaps something like
=AGGREGATE(16,6,B1:B15/(A1:A15=Condition),0.5)
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks