I Have 12 months sales history on an item. rather than work out the average
over the 12 months data, I wont to enter a formula that will give me the
average of the 6 highest selling months. Is there a way I can do that? I
have my data set out in rows with calendar month headings across the top.