Hi,

Assuming your data goes from row 1 to row 1000 (adjust the below ranges to suit your actual needs), put this formula in cell J1:

=COUNTIF(F1:F11000,1)

Then enter this **array formula**** in your first cell of choice:

=IF(ROWS($1:1)>$J$1,"",INDEX($B$1:$B$1000,SMALL(IF($F$1:$F$1000=1,ROW($F$1:$F$1000)-MIN(ROW($F$1:$F$1000))+1),ROWS($1:1))))

Copy this formula down (though not the one in J1 - that's a one-off calculation) until you start to get blanks for the results.

Note that this solution depends on your values in column F being the **numerical** 1, and not the **text entry **1 which just happens to look like the numerical version. If you're not sure, pick one of the cells containing one of these 1s, e.g. F3, and enter this formula in another cell somewhere:

=ISNUMBER(F3)

A TRUE will confirm that it is indeed a number, and so you have nothing to worry about!

Regards

***Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).*