Hello everyone, my name is Guillermo and I'm new to the forum. I have some experience with excel and work with excel but simply go along learning what I have to use on the web.

I now have this question and have not been able to find an answer to it anywhere.

So,
I have a sheet in excel that is filled out. Lets say from A1:F5

Ex.
Name Status Program Contracter Date Station
John 1st Medical Doe 1-may Miami
Bob 1st Cook Sagget 5-may WPB
Rick 1st Medical Ross 10-may FTL
Will 3rd Driver Smith 16-may Miami

So I would like to form a list starting in a DIFFERENT Sheet column B, cell B1 , that meet certain criteria, and continue down B1, B2, B3 etc. until there are no more left .

So Lets say I wanted all the names of those in Program= Medical AND Status= 1st listed, I would get in cell B1= John and B2= Rick

I do not with to set filters, I need the original list as is and want to have this in a totally different sheet.

And I plan to use different criteria in different columns.

Thank you in advance for the help.