•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Can't understand the difference between these two functions
=MEDIAN(IF(($A$2:$A$32673=$AA2)*($M$2:$M$32673<>""), $M$2:$M$32673))
=MEDIAN(IF(AND(($A$2:$A$32673=$AA2), ($M$2:$M$32673<>"")), $M$2:$M$32673))
If one is working, the other should too-? (top one works)
Latest version of Excel (I doubt spreadsheet is needed to be shown since I just wanna know difference in why the top one is working and bottom one isn't)
[link] [comments]
Want to read more?
Check out the full article on the original site