Hi Gurus
I am trying to come up with a formula which will allow me to get Column G in my attached spreadsheet.
Column F formula gives me the the top 5 average and it corresponds to sites 11 - site 15 (Column A). I want column G to give me the Last year figures for the same sites column F picked out (sites 11-15) and give me the average for them. Is there a neat way to do this without using any helper columns?
Bookmarks