Hi all,

I have a summary page which shows total figures to do with outstanding debt owed to my company.

I use a database which just refreshes each month and a number of sumif, vlookup or whatever link it all through to the summary page. A while ago someone who receives the report asked me to add the top 10 overdue accounts as well. Because the customers can change each month the way i did this was to add a rank calculation to my data report and vlook'd up the rank. This all works fine and I'm happy with it.

I'm now looking to produce a different report for my international region and I want to top 10 by country. The problem I have is the report is all in one, so I will have UK, Spain, France all in one report, therefore If I rank it will rank by all countries. Is there anyway to rank by each country. A sort of "Rank if" function.. or is there are what of vlookuping just the top ten?

Thanks

Carl