I have a sheet with the following detail which I wish to Return the Top
5 Sales Locations only in Sheet2. My summary detail is as follows all
located on Sheet 1

ColA = Location Name
ColB = Sales Revenue
ColC = Sales Ranking Number (1 = highest)

On Sheet2 I wish to just see whatever locations are in the Top 5 with
their respective Sales revenue Amounts, so eg

London £10,750 Rank No 1
Paris £7,500 Rank No 2
etc until I show the Top 5

I have 35 locations in total on Sheet1

Thanks