there are 3 columns
1: name of the company
2: the sector it belongs (food,beverage...)
3: net sales


i want to find out the largest or smallest (doesnt matter) 3 (or 5
whatever) net sales of each sector ( and hide all other rows) (in
ascending or descending format)

is it be so difficult to write a macro like that)


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

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=396461