How to Calculate Average of Top 2 or more values in a data set in Excel - Office 365

To find the average of the top 2 or more values in a data set you can use a formula based on the LARGE and AVERAGE function.

To download the example Excel file please click on the link below

[post]

Is there a way to change the title with in (many) cells so that "The" comes at the end? For example;
The Beatles to Beatles, The
The Rolling Stones to Rolling Stones, The
The Da Vinci Code to Da Vinci Code, The
etc.?

[md.tayebur]

average top 3 out of 5 in excel, if value is 2, #NUM! error