Skip to content

Instantly share code, notes, and snippets.

@davecurrierseo

davecurrierseo/Concatenate Array Formula in Google Sheets

Last active August 5, 2021 18:31
Show Gist options
  • Save davecurrierseo/d33ba75f62a5b9da4554 to your computer and use it in GitHub Desktop.
Save davecurrierseo/d33ba75f62a5b9da4554 to your computer and use it in GitHub Desktop.
Download ZIP
Google Sheets Cheat Sheet
Raw
Concatenate Array Formula in Google Sheets
=ArrayFormula(if(len(B2:B),B2:B&" "&C2:C&" "&E2:E,iferror(1/0)))
Raw
Count How Many Times Data Occurs Within A Range
=ArrayFormula(if(row(B:B)=1,"Title of Column",if(len(B:B),countif(unique(match(B:B&C:C,B:B&C:C,0)+match(B:B&C:C&H:H,B:B&C:C&H:H,0)/50000),"<="&match(B:B&C:C,B:B&C:C,0)+match(B:B&C:C&H:H,B:B&C:C&H:H,0)/50000)-countif(unique(match(B:B&C:C,B:B&C:C,0)+match(B:B&C:C&H:H,B:B&C:C&H:H,0)/50000),"<"&match(B:B&C:C,B:B&C:C,0)),)))
Raw
Sort
# This will sort all data on sheet "name of tab" on cells a:l in descensing order
=sort('Name-of-tab'!A2:L, 1, false)
Raw
Vlookup to return YesNo
=ARRAYFORMULA(IF(ISNA(VLOOKUP(B2:B,Sheet9!A1:A,1,FALSE)), "❌", "❎"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment