https://docs.google.com/spreadsheets/d/1tPpjeILWi8ujMKCny-LrsZHkylEtrrAywz_Z14dBqk0/edit
https://www.pigzilla.co/articles/15-insanely-efficient-google-sheets-formulas-for-seos/
=countif(A:A,A:A)>1
=countif(A:A;A1)>1
=countif($A$1:$A,A2)>1
=A1&B1
=COUNTIF($A$2:G,Indirect(Address(Row(),Column(),)))>1 [DUPLICATE TEXT FROM DIFFERENT COLUMN]
=COUNTIF($A:$A,"TEXT") [COUNT THE INSTANCES OF 'TEXT']
=$A1>=LARGE($A$1:$A$10,5) [HIGHLIGHT TOP 5]
=REGEXREPLACE(A1,"\?[^?]*$","") [REMOVE URL PARAMETERS]
=SUBSTITUTE(LOWER(JOIN("-",A2))," ","-") [LOWER CASE+REPLACE SPACE]
=regexmatch(A1,"\s(KW1|KW2|KW3)")
=regexmatch(A1," (KW1|KW2|KW3)")
=REGEXEXTRACT(A2,”^(?:https?:\/\/)?(?:[^@\n]+@)?(?:www\.)?([^:\/\n]+)”)
=IFERROR(ARRAYFORMULA(REGEXEXTRACT(A2:A,”^(?:https?:\/\/)?(?:[^@\n]+@)?(?:www\.)?([^:\/\n]+)”)),“”)
=IF(SEARCH(“/blog/”,A2),“YES”,“”)
=REGEXEXTRACT(FORMULATEXT(A1),"""(.+?)""") [EXTRACT URL FROM LINK]
=LEFT(A2,FIND("/",A2,9)-1) [EXTRACT DOMAIN FROM URL]
=LEFT(A2,FIND("$$$",A2)-1) [EXTRACT ALL BEFORE $$$]
=RIGHT(A2,LEN(A2)-FIND("$$$",A2)) [EXTRACT ALL AFTER $$$]
=LEFT(B2,len(B2)-3) [TRIM LAST 3 CHARACTERS]
=(A1-A2)/A2 [DIFFERENCE IN %]
=counta(F3) + sum(arrayformula(len(regexreplace(F3, "[^\n]", ""))))
^((?!TEXT).)*$ [REGEX EXCLUDING TEXT]
\?.*
^\s*$ [SELECT BLANK CELLS]
=INDIRECT(ADDRESS(ROW(),COLUMN()-1)) [VALUE FROM CELL ON THE LEFT]
=split(A1,char(10)&",") [SPLIT CELL CONTENT INTO COLUMNS]
=LEFT(A2,FIND("(",A2)-2) and =MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1) [SPLIT CELL TEXT WITH BRACKETS]
=AND(REGEXMATCH(A:A, "(?i)KEYWORD1"), NOT(REGEXMATCH(A:A, "(?i)KEYWORD2"))) [SHOW CELLS WITH KEY1 BUT NOT KEY2]
=SPARKLINE [TRENDS]
='Sheet Name'!A1 [REFERENCE CELL FROM DIFFERENT SHEET]
=match(A1,indirect("'Sheet Name'!A2:A"),0) [CONDITIONAL FORMATTING FROM DIFFERENT SHEET]
=REGEXREPLACE(A11,"\D+", "")  [REMOVE CHARACTERS AND LEAVE NUMBERS]
\D+  [FIND NUMBERS]
=UNIQUE(A1:A) [REMOVE DUPLICATES]
=IFERROR([FORMULA],"[NEW ERROR]") [REPLACE #N/A, #VALUE! or #NUM!]
=IMPORTXML("https://www.mysite/sitemap.xml", "//*[local-name() ='url']/*[local-name() ='loc']") [IMPORT ALL URLs IN SITEMAP]
([^” “]*\s){X,}? [GSC QUERIES WITH X+1 WORDS]
(\w*\W){X,} [GSC QUERIES WITH X+1 WORDS]



2 word phrases » ^\w+\s+\w+$
2+ word phrases » (\w+\s+\w+\s?)+
queries with symbols » [^a-z0-9\s]+