I have a sheet with a Profit and loss statement. The headings are on the first column and the figures are in columns (named by corresponding month the data relates to).

If I use auto filter to get the top ten figures, it sorts data just for one month and the rest are ignored. I understand the logic behind it. The other (successful) way to do this is to use individual pivot charts for all months and then sorting them, ultimately building separate tables.

Is there some way to build a top ten list out of a data table composed of multiple colums to display without using auto filter and/or pivot table, simply by using excel formulas and functions.

Spreadsheet looks like this:
Index Jul-07 Aug-07 Sep-07
6-2160 Taxis - Parking $1,041.53 $1,519.25 $507.11
6-2165 Motor Vehicles Lease $1,159.32 $1,159.32 $1,159.32
6-2170 Motor Vehicles Insurance $283.81 $281.05 $281.03
6-2175 Motor Vehicles Fuel $451.43 $447.77 $262.11
6-2180 Motor Vehicles Other $0.00 $2,486.26 $1,909.09
6-2185 Motorpass Administration Fee $0.00 $0.00 $0.00
6-2210 Telephone Landline $1,540.86 $4,859.54 $536.03
6-2215 Telephone Mobile $1,234.49 $420.64 $727.23
6-2225 Couriers $0.00 $0.00 $0.00
6-2230 Member & Sub Other Org $0.00 $0.00 $0.00
6-2240 Internet Admin $852.37 $2,672.64 $109.05
6-2280 Directors Conference/Training $0.00 $0.00 $0.00
6-2290 Bank Charges $171.90 $53.95 $410.74
6-2295 Interest On Business Loan $1,405.18 $0.00 $0.00
6-2296 Interest - Hire Purchase $0.00 $0.00 $0.00
6-2300 Interest on Overdraft $1,202.01 $1,737.95 $1,633.67
6-2310 Interest on Citibank Interest $0.00 $0.00 $0.00

Desired result is

Jul-07
(Top Expense 1) Name of Expense Amount
(Top Expense 2) Name of Expense Amount
and so on....