Aug 19 2020 08:50 AM
Hi. I have two columns A and B. I would like to calculate the median of the data in A only if it in B says "Yes". Can anybody help my with the command for this? Thanks
Aug 19 2020 09:52 AM
@luna155
I used a third column saying if(B1="Yes",A1,"")
then I took the median of column C
see the attached file
Aug 19 2020 02:31 PM
As variant
=MEDIAN(IF(B:B="Yes",A:A))
using as it is on Excel with dynamic arrays or entered as array formula by Ctrl+Shift+Enter in other case.
Aug 21 2020 03:24 AM
Thank you very much - was a great help! @Sergei Baklan
Aug 21 2020 03:51 AM