Good afternoon all.

I have two columns where I input data onto sheet 'applications'.
Column A I input a loan number and in Column P, I enter the outcome of the loan.
Some loans are finalised and some are still 'processing' and the list I want to build is the loans that are 'processing'.

So, on another sheet, 'Input' in Column Q, I would like to build a new list of the loan numbers that have 'processing' in column P.

Hope that makes sense.

I have seen it somewhere before but have no idea of the words I need to search. Nothing is coming up with what I have tried.

Thanks
Tayler