/SQL/Google sheets filter rows above current cell

Google sheets filter rows above current cell

-- 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

Similar codes

5 votes264 views1 answer
Oracle create table comment
SQL
1 vote297 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
0 vote272 views1 answer
Authentication in sql server
SQL
11 votes259 views1 answer
Ddl materialized view
SQL
10 votes253 views1 answer
How to import database in mysql by cmd
SQL
0 vote280 views1 answer
Get current date data in mysql
SQL
0 vote296 views2 answers
Impala rename column name
SQL
22 votes285 views4 answers
Date format mysql
SQL
4 votes405 views6 answers
Laravel jwt
SQL
1 vote246 views1 answer
Mysql average of multiple columns
SQL