FILTERING QUESTION

[meppwc]

I have a spreadsheet where as columns L, M, N, O all have numbers in them. There are over 6000 rows.
I am looking for a quick way to filter those columns to where I can see only rows where the value in any of the columns mentioned, are less that 20.

 

[dreid1011]

Nvm, doesn't quite work that way.

Maybe this though:

=IFNA(HSTACK(FILTER(L2:L6001,L2:L6001<20),FILTER(M2:M6001,M2:M6001<20),FILTER(N2:N6001,N2:N6001<20),FILTER(O2:O6001,O2:O6001<20)),"")

 

[Fluff]

How about

=FILTER(L2:O10000,BYROW(L2:O10000,LAMBDA(br,COUNTIFS(br,"<20"))))

 

[dreid1011]

How about

=FILTER(L2:O10000,BYROW(L2:O10000,LAMBDA(br,COUNTIFS(br,"<20"))))

Tested out of curiosity, and it is still showing values >20.

 

[Fluff]

My take is that the entire row should appear if any one of the cells is <20.

 

[dreid1011]

My take is that the entire row should appear if any one of the cells is <20.

Oh okay, I see.

 

[meppwc]

Correct, the entire row should appear if any of the columns mentioned is <20

 

[Fluff]

Have you tried the formula I suggested?

 

[meppwc]

Not sure where the formula should be input?

 

[Fluff]

Wherever you want to put it.