Large - show top 5 $ accounts

[bluepenink]

Hello

I'm having trouble trying to figure a method on how to show
a) top 5 revenue generating accounts by TOWN & INVOICE TYPE

basically, i have a town name and i want to know from that town, what 5 account #s generating the greatest revenue.

D4 = town name (i.e. New York)
E4 = invoice type (i.e. Auto)

source table:
$D$19:$D$4634 = town name in source table
$E$19:$E$4634 = Account # -> i need to show this
$F$19:$F$4634 = invoice type (Auto, offsite etc)
$S$19:$S$4634 = YTD $

NEED:
so I need
top 5 $ accounts by YTD
Rank, Account #, YTD $
1. 01123 $800
2. 05487 $741
3. 09857 $657
4. 03654 $254
5. 07847 $100

Can someone pls help with this issue as i need to organize it similar to the table above, pls and thx u

Thx u (i am using excel 03).

 

[rdw72777]

Have you tried setting up a pivot table using your entire data range ($d$19:$s$4634)? You could then make your row fields (Town Name, account #, invoice type) and column fields (YTD Revenue) to setup your pivot. You can then filter the pivot on town name and invoice type, and then filters your YTD revenue using a Value filter, choose top 10, and then adjust it to show top 5.