/SQL/Google sheets data validation custom formula filter

Google sheets data validation custom formula filter

-- Google Sheets: Using filter()
--   in custom formula in data validation

=query(filter('sheet1'!$A$2:$A, 'sheet1'$A$2:$A < 4),
       "select Col1 where Col1 = '" & 'sheet2'!A2 & "'")
       = 'sheet2'!A2

-- Note: The 'sheet2'!A2 must be
--   the first (top-left) cell of the validated range

Similar codes

2 votes270 views1 answer
Oracle index size
SQL
0 vote279 views1 answer
Mysql sql select one day before
SQL
3 votes306 views1 answer
Start mysql server linux terminal
SQL
2 votes269 views1 answer
Query to find table size in oracle 12c
SQL
0 vote261 views1 answer
Sql examples from your work
SQL
0 vote272 views1 answer
Mysql get last 2 month data
SQL
22 votes362 views4 answers
Mysql format date
SQL
1 vote267 views1 answer
Not exists mysql
SQL
0 vote277 views1 answer
Mariadb hours between two dates
SQL
1 vote277 views1 answer
Postgresql escape single quote
SQL