Forum Discussion
Dineshja48
May 31, 2023Copper Contributor
Finding error while calculate median for a Groupby - array returns zero with other values.
I'm trying to calculate a median value at group by operation but not finding correct answer. In my example i've material and plant information and want to know the total spend median value at each ma...
- May 31, 2023
Try
=MEDIAN(IF(($A$2:$A$11=A2)*($B$2:$B$11=B2),$D$2:$D$11))
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter
HansVogelaar
May 31, 2023MVP
Try
=MEDIAN(IF(($A$2:$A$11=A2)*($B$2:$B$11=B2),$D$2:$D$11))
If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter
Dineshja48
May 31, 2023Copper Contributor
Thank you Hans! its working..