I would only like the values in Column A to return if there is a value of >1 in Column B - I am unsure on a formula to do this
1 Answer
Use filter()
, like this:
=filter(A57:A66, B57:B66 > 1)
Use filter()
, like this:
=filter(A57:A66, B57:B66 > 1)