Hi there, I need some help in finding a solution to my problem. I am building a football stat database which I am looking to put in an individual sheet which will search the other 20 sheets, collate the information and then display a top 5 ranking in each area. For example, this is our setup for the data:

Screenshot 2014-03-12 21.56.18.jpg

So what I want to to is have a separate sheet which will have a section for say over 1.5 goals %. The formula would go and retrieve all of the % results for each individual team. Then it would rank the 5 best teams and display the team name in the first cell and the % in the other cell.

Is that possible? I just can't seem to get my head round trying to do this.

Thanks

Andy