View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
owl527
 
Posts: n/a
Default location of cell


Hi, this is similiar to what I am looking for, HOWEVER, I guess mine is
a bit more complicated because I have an extra column. e.g.
Column 1 - Countries (HK, US, UK)
Column 2 - Products (Banana, Apple, Orange, Grapes, Carrot, Potato,
Tomato)
Column 3 - values (numbers)

I would like to sort the top 5 product Per country.

Sample end result:
HK
Banana 240
Apple 137
Tomato 122
Orange 82
Apple 23

Please help! thanks!!!


--
owl527
------------------------------------------------------------------------
owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=499654