E
E
Eugene Dragan2021-02-03 11:16:37
Google Sheets
Eugene Dragan, 2021-02-03 11:16:37

How to filter by formula in Google Sheet?

How to filter using a formula on column B so that only the result is less than or equal to 2500 in the output.

To understand and visualize the situation, I made a small table https://docs.google.com/spreadsheets/d/1ITEVisJsYq...

I would be very grateful for help.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2021-02-03
@dragan2011

Perhaps
=FILTER(A1:A5;B1:B5<=2500)
601a5f2926227276471539.png
More about FILTER https://contributor.pw/post/google-sheets-formulas...

A
aminodovborisov, 2021-02-03
@aminodovborisov

Try Conditional Formatting .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question