•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
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#MEDIAN
#IF
#Excel
#$A$2:$A$32673
#$M$2:$M$32673