▲ 19 r/excel
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 in D9, grabbing scores from P, Q, R -> AQ9:
=AVERAGE(TAKE(FILTER(J9:AQ9, (J9:AQ9<>0)*(J9:AQ9<>" ")), 1, -4))
Editing to add a screenshot for context:
u/AshaBaejoy — 22 days ago