I have got a column with data and I want to calculate the median excluding some values.
=median(B2:B40)
There is an indicator column in A2:A40: 1= value in column B has to be included in the calculation of the median and 0= value in column B has to be excluded.
If possible: no arrays formula
Thank you for your help.