Filter function possible with multiple columns?

Hi all,

Is it possible to use the filter function on multiple columns?

=FILTER(AH1:AI11049,AH1:AH11049="Blue","")

I want columns AH to be my 'point' of filter - Blue. I want data returned from column AA, AB, AD, AE, AI, but only for the data where column AH is Blue. Is this possible with the filter formula?

thanks

Tricky without a sample sheet but this *might* work:

Please Login or Register  to view this content.

WBD