After a long search I found a post which was trying to do what I am currently stcuck with. The post is here -
I have adapted the offset formula for my spreadsheet, but could do with some help with what to do if 2 values tie.
I need the top 10 values to populate my chart, but if there are two values which rank joint first place, the formula only extracts the first value. Is there any way I can get round this?
thanks in advance