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)
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityUse filter()
, like this:
=filter(A57:A66, B57:B66 > 1)