Re: $$Excel-Macros$$ Top Three

Hello, Thank you very much. On Tue, May 15, 2012 at 4:14 PM, Krishna Kumar wrote: > Hi > > In G1: 3 > > In H2 and copied down, > > =IF(ROWS(H$2:H2)<=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),"") > > In I2 and copied down, > > > =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1)

Re: $$Excel-Macros$$ Top Three

Hi In G1: 3 In H2 and copied down, =IF(ROWS(H$2:H2)<=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),"") In I2 and copied down, =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1),COUNTIF($H$2:H2,H2))),"") It's an array formula. Confirmed with CTRL + SHIFT + ENTER Kris ExcelFox