Why doesn't the formula i'm using allow me to get the average of this set of values?
Formula {=INDEX($C$2:$C$298,MODE(MATCH($C$2:$C$298,$C$2:$C$298,0)))}
Example Image.png
Here's a one drive link for the actual example sheet i made, can't upload from Work PC: https://1drv.ms/x/s!AjprUFOn0j6KhiWtb2FDffoEGnBM
Thanks,
Liam
Bookmarks