I have information is several columns. Column A contains names, column B
contains addresses and column c contains rent payment. I need to be able to
see the top 5 highest rents paid along with name and addresses. I can do
this by using a filter and works fine. However each of columns A,B and C are
repeated 12 times for Jan-Dec therefore D,E and F would now represent Feb
etc. Of course each of the different months contain varying data.

On a separate part of the spreadsheet I would like to be able copy using a
formula to automate for another user the spreadsheet to automatically grab
the top five rents, name and addresses (a grouping of three columns) for all
of the single months without having to use a filter. Essentially a copy of
the original figures but just showing the top 5 rents from each month.

Many thanks for taking the time to read this and any and all help welcome.
Hope the above explains in enough and yet not too much details.

Debbie D. (UK)