Pls help passing all the data with specific test to sheet 2

[thelo.gwapo]

so i have here a file which has a data with step
the sheet 1 contains all the data and i want the sheet 2 to only contain those with string STEP
i dont wanna use sort/filter so pls help here's the file

[azumi]

Put in cell B3 on SHeet2

=IFERROR(INDEX(sheet1!B$3:B$100,SMALL(INDEX((sheet1!$M$3:$M$100="STEP")*(MATCH(ROW(sheet1!$M$3:$M$100),ROW(sheet1!$M$3:$M$100)))+(sheet1!$M$3:$M$100<>"STEP")*1048577,0,0),ROWS($A$1:A1))),"")


copied down and cross until blank results

[thelo.gwapo]

Put in cell B3 on SHeet2

=IFERROR(INDEX(sheet1!B$3:B$100,SMALL(INDEX((sheet1!$M$3:$M$100="STEP")*(MATCH(ROW(sheet1!$M$3:$M$100),ROW(sheet1!$M$3:$M$100)))+(sheet1!$M$3:$M$100<>"STEP")*1048577,0,0),ROWS($A$1:A1))),"")


copied down and cross until blank results

thanks! this solves my prob

[azumi]

glad it worked

cheers
Azumi