INDEX SMALL array formula issue

Hi. I'm trying to use the formula below to pull the values from column B according to the values in column A. I copied this from another website which I can't find any more unfortunately.

Please Login or Register  to view this content.

This is then made into an array formula to display the values from column B that have a value of "1" in column A in a separate column. I have values from 1-10 in column A which I wish to sort into separate columns, one column for value 1, one column for value 2, and so on, and will have additional formulas for that further across the sheet.

The problem I have is that this formula will only display the first matching value in the data. As I understand it the ROW(A1) function at the end is there to increment the data, increasing by 1 with each row it is copied down.

However, when I try and make the array formula (select the range, paste the formula into the bar, and then Ctrl-Shift-Enter) the A1 reference doesn't increment, meaning that I only ever get the first value. Could anyone advise what I'm doing wrong?

just enter it in a cell array enter it then fill down

You dot really need the false argument("")
You can make this faster avoiding the MIN function and use ROWS not ROW for k argument of SMALL to prevent formula to stop working when new row is adedd/deleted:
=INDEX($B$2:$B$50, SMALL(IF($A$2:$A$50=1, ROW($A$2:$A$50)-ROW($A$2)+1), ROWS($A$1:A1)))