•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Calculate 5 cell values, drop highest and lowest value, and provide an average of the remaining 3 values
The formula I currently have only seems to get 4 cells rather than the intended 5. It was working as-is, pre-upgrade to MS365 (2024). I feel like I'm missing something basic!
The formula should take 5 cells of the most recently input scores, drop the highest and lowest, then average the remaining 3 scores.
The current formula:
=AVERAGE(TAKE(FILTER(J9:AQ9, (J9:AQ9<>0)*(J9:AQ9<>" ")), 1, -4))
Editing to add a screenshot for context:
[link] [comments]
Want to read more?
Check out the full article on the original site