Forum Discussion
Excel formula for finding, ranking and returning nth value
Can anyone explain what formula or array formula I'd need for the following: Scenario - school cross country results Each school may have six runners but only the top four score. Column A lis...
Thank you for your efforts.
Without understanding the language of the functions and formulas I think I am destined to fail - when using your formula I either get a #ref or #name error.
Additionally, I want to transfer this to Google Sheets which my school uses, but it doesn't recognise the aggregate function.
Unfortunately I am no closer to a solution.
Thanks again
rjtomkinson Sorry to hear. I know nothing about GS, so I can't help you any further.