Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find Top Spenders?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find Top Spenders?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find Top Spenders?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |