**Array Formulas**Cell | Formula |
---|
H2 | =IF(ROWS(H$2:H2)<=$E$2,INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D$2,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(H$2:H2))),"") |
---|
I2 | =IF(ROWS(I$2:I2)<=$E$2,INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D$2,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(I$2:I2))),"") |
---|
F2 | =IF(ROWS(F$2:F2)<=$E$2,INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D$2,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(F$2:F2))),"") |
---|
F3 | =IF(ROWS(F$2:F3)<=$E$2,INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D$2,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(F$2:F3))),"") |
---|
F4 | =IF(ROWS(F$2:F4)<=$E$2,INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D$2,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(F$2:F4))),"") |
---|
F5 | =IF(ROWS(F$2:F5)<=$E$2,INDEX($B$2:$B$7,SMALL(IF($A$2:$A$7=$D$2,ROW($A$2:$A$7)-ROW($A$2)+1),ROWS(F$2:F5))),"") |
---|
**Entered with Ctrl+Shift+Enter** |

## Like this thread? Share it with others