View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
william4444
 
Posts: n/a
Default Extracting Top 5 & Bottom 5 Variance for Revenu/Expendenture &


Hi Marcelo,

Ideally what i said in the previous post. I guess what am after is
something that can be automated on it's own, maybe a Macro button on
another sheet where as i just press it & it will give me the Top 5 for
ALL Catogoriers, would be great.. Have a look at the attachment i've
only put in a few thou the list will grow down to about say 110 rows.
Hope you could help much appreciate it

Cheers
Will


+-------------------------------------------------------------------+
|Filename: Book22.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4921 |
+-------------------------------------------------------------------+

--
william4444
------------------------------------------------------------------------
william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991
View this thread: http://www.excelforum.com/showthread...hreadid=553820