F
Frank Kabel
Hi
enter the following array formula in C1 (entered with
CTRL+SHIFT+ENTER):
=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=1,ROW($A$1:$A$100)),ROW(1:1)))
and copy this down
enter the following array formula in C1 (entered with
CTRL+SHIFT+ENTER):
=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=1,ROW($A$1:$A$100)),ROW(1:1)))
and copy this down