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

$$Excel-Macros$$ Top Three

Hello, Could you please help me in the formula. Please find attached file. Thanks in advacne. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem