Transferring filtered data from one table to another

[ehassell01]

The objective and examples are provided. I finally took the time to layout the desired outcome and I can see this could be above my knowledge level, even though I'll be plowing into it in the next two weeks. In any case, I could use anything from some insights to a solution to transfer to the final project.

Thanks.

[contaminated]

Hi and welcome to the board

Try in B18

Please Login or Register  to view this content.

As it is array formulae, Confirm with <Ctrl>+<Shift>+<Enter> then Copy down

In C18

Please Login or Register  to view this content.

copy down then accross
I can up;od workbook if u'd like

[contaminated]

I'm uploading workbook with ready for me sample...

[ehassell01]

Thank you Vusal M. Dadashev. I appreciate the help.