Filter ...Skip one Column

[ionelz]

Hi,
Please help with this :

=SORT(FILTER(Data!C4:I5000,(Data!H4:H5000=$G$2)*(Data!C4:C5000<>"")))

This formula works but I want to SKIP column H
So : C , D, E , F, G , H , I ...need to exclude H
Thank you

 

[Eric W]

Try:

=INDEX(SORT(FILTER(Data!C4:I5000,(Data!H4:H5000=$G$2)*(Data!C4:C5000<>""))),SEQUENCE(ROWS(FILTER(Data!C4:I5000,(Data!H4:H5000=$G$2)*(Data!C4:C5000<>"")))),{1,2,3,4,5,7})

This can be shortened a bit if you have the LET function.

 

[Fluff]

Another option

=FILTER(SORT(FILTER(Data!C4:I5000,(Data!H4:H5000=$G$2)*(Data!C4:C5000<>""))),{1,1,1,1,1,0,1})

 

[ionelz]

Thanks all, that is what I need !

 

[Fluff]

Glad we could help & thanks for the feedback.