Combining 2 formulas

[Dummy Excel]

Hi,
i have two formulas

=INDEX(Raw!A:A,COUNTA(Raw!A:A)+ROW(Raw!A:A)-ROW(),1)

and

=filter(Raw!B:B,Raw!$B:$B<>"Completed (Repairs completed, Available and safe to use)")

is there a way that i can combine both formulas in one?

thanks
Sam

 

[Peter_SSs]

Filter() isn't a function in Excel (at least not in any version I have used). Perhaps you are asking a Google sheets question in an Excel forum?