I have 2 columns

• name
• age

On another sheet, I want to create a column that lists all the names whose ages are over 30.

Is there a function that allows me to do this?

CodePudding user response：

Use:

=FILTER(A:A; B:B>=30)

Or:

=QUERY(A:B; "select A where B >= 30"; )