Skip to main content
Web Applications

Return to Question

added 151 characters in body; edited tags
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

I have this formula in E2: =FILTER(A1:C20,B1:B20=2) and need to perform substitute like:

1

https://docs.google.com/spreadsheets/d/1GMXdSMlti4mxXJmpMPamveqwmu148FZz_MTLm2m9Cno/edit?usp=sharingspreadsheet here

Suggestions on making method 2 work? I'm hoping to do the formula in a single cell, without additional columns.

https://docs.google.com/spreadsheets/d/1GMXdSMlti4mxXJmpMPamveqwmu148FZz_MTLm2m9Cno/edit?usp=sharing

Suggestions on making method 2 work? I'm hoping to do the formula in a single cell, without additional columns.

I have this formula in E2: =FILTER(A1:C20,B1:B20=2) and need to perform substitute like:

1

spreadsheet here

I'm hoping to do the formula in a single cell, without additional columns.

Source Link
Allen Sierra
Allen Sierra
  • 55
  • 1
  • 7

Perform operation on specific column in filtered range, right after filtering

https://docs.google.com/spreadsheets/d/1GMXdSMlti4mxXJmpMPamveqwmu148FZz_MTLm2m9Cno/edit?usp=sharing

Suggestions on making method 2 work? I'm hoping to do the formula in a single cell, without additional columns.