Hi,

I have a spreadsheet with the following format:-
ColA, ColB, ColC, ColD
CustomerName, 2004 Spend, 2005 Spend, 2006 Spend

How can I extract the Top Three Spenders for each of the three years
and show it in a summary sheet?

If I was to have an extra Col showing Magazine Name could I show the
Top Three Spenders for each year by magazine?

I have tried using a pivot table but to no avail.

Regard
Garry


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=544955

Gazzr:

If you arrange your data as follows, a pivot table should work:


Col A = CustomerName
Col B = Magazine
Col C = Year
Col D = SpendingAmount

In the pivot table:

Use Field Settings Advanced Top 3


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=544955

Thats excellent thanks mate.

Gazzr


--
Gazzr
------------------------------------------------------------------------
Gazzr's Profile: http://www.excelforum.com/member.php...o&userid=31075
View this thread: http://www.excelforum.com/showthread...hreadid=544955