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
-
by "return", do you mean visibility?– DanieleMay 17 at 6:30
1 Answer
Use filter()
, like this:
=filter(A57:A66, B57:B66 > 1)