Excel Does Median Ignore Blanks

[Solved] Excel Does Median Ignore Blanks | Vb - Code Explorer | yomemimo.com
Question : excel does median ignore blanks

Answered by : ana-faria-carneiro

=MEDIAN(IF(A1:A2000=15,IF(B1:B2000<>"",B1:B2000)))

Source : https://www.mrexcel.com/board/threads/median-formula-to-ignore-blank-cells.273433/ | Last Update : Thu, 08 Sep 22

Answers related to excel does median ignore blanks

Code Explorer Popular Question For Vb