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