Filter re arranged non adjacent columns

Hi I've been using the formula

INDEX(range,SEQUENCE(ROWS(range)),{2,5,3})

To rearrange columns but I want to then filter the resulting data,

FILTER(INDEX(range,SEQUENCE(ROWS(range)),{2,5,3}),criteria range="criteria")

I can't see what I'm doing wrong, I've attached a simple example please help.

Richard

How about filtering 1st, like

Formula:

Please Login or Register  to view this content.

Thanks, all sorted.

RD

That's interesting, not tried it but I'll look into it. I've only used Let at very simple calculation to see how it worked.

RD

Glad to help & thanks for the feedback.