I have this formula in E2:
=FILTER(A1:C20,B1:B20=2) and need to perform substitute like:
I'm hoping to do the formula in a single cell, without additional columns.
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 community