Filter formula for selected columns only

[creative999]

Hi

Im trying to pull data from different columns, but the columns i need arent next to each other or in a different order:

This works:
=FILTER(B2:Z200,LEFT(Y2:V200,LEN(A2))=A2,"NONE")

But i only want to show columns G, H, B AND Y (in this order).

Any suggestions?

 

[dreid1011]

You can use CHOOSECOLS around your filter, like this:

=CHOOSECOLS(FILTER(B2:Z200,LEFT(Y2:V200,LEN(A2))=A2,"NONE"),6,7,1,24)

 

[creative999]

Another question, how would i sort this by column H?
And column G is a date range but how do i only filter those for 2025?