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