Mon Aug 12 2024 12:13:04 GMT+0000 (Coordinated Universal Time)
Saved by @baamn #sheets
=COUNTIF (A:A, A1)>1
#google #sheets
#gquery #sheets
WHERE A MATCHES '"&TEXTJOIN("|",true,E1:E)&"'
=index(split(B2,"/"),len(B2)-len(substitute(B2,"/",""))+1)
#sheets
#sheets #googlesheets
=REGEXREPLACE(A2, "\s", "_")
Copy this HTML code:
Preview:
open_in_newInstructions on embedding in Medium
Comments