Yuliya Charapanava
Yuliya Charapanava
Programming language:SQL
2021-05-03 21:23:25
0
Q:

google sheets filter rows above current cell

Dinny
Dinny
Code: SQL
2021-07-05 00:26:19 
-- Google Sheets: Filter rows above current cell
=filter(
  indirect("R2C3:R" & row()-1 & "C3", false),
  indirect("R2C3:R" & row()-1 & "C3", false) = "Search Word"
)
  
-- Note: Use must use R1C1 notation, not the A1 notation
0

Tags

New to Communities?

Join the community