A formula I've found to work for this basic case is as follows, but must be entered as an array (ctrl+shift+enter):
=MEDIAN(IF(A:A=1, B:B))
Thanks All!
A formula I've found to work for this basic case is as follows, but must be entered as an array (ctrl+shift+enter):
=MEDIAN(IF(A:A=1, B:B))
Thanks All!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks