I would avoid the Macro and just use a Pivot Table. Select the Data and
choose Data - Pivot Table. Follow the wizard. Place the company and the
sector in the left hand column. Place the sales in the middle. Right click on
the sector and choose Field Settings - Advanced and modify the Auto Show
options to show only the top 3.
--
HTH...

Jim Thomlinson


"barkiny" wrote:


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