Photo by Dominik Scythe on Unsplash

Google Sheets - Query & Other Functions

IF & IFS Functions

June 15, 2019

 

Combine Cell Contents

June 15, 2019

  1. =B2&” “&C2
  2. JOIN(delimitervalue_or_array1[value_or_array2, …])
    • =TRIM(JOIN(” “,B12:C12,E12, D12)) Mr. Robert B Haight 
    • TRIM: to eliminate the space
  3. TEXTJOIN(delimiterignore_emptytext1[text2, …])
    • =TEXTJOIN(” “,TURE,B12:C12,E12, D12)) Mr. Robert B Haight 
    • TRUE: to ignore the empty space
  4. SUBSTITUTE(text_to_searchsearch_forreplace_with[occurrence_number])

Apply to: combine first name & last name into Name.

=B2&” “&C2

Combine Data From Multiple Sheets

April 4, 2019

Learn how to Combine Data From Multiple Sheets (Tabs) in Google Sheets using arrays & QUERY Function and make an automatic master sheet with all the data combined into one tab.

Apply to Monthly Expenses:

=QUERY({GoDaddy!B3:L;’Media Temple’!B3:L;Flywheel!B3:L;MailChimp!B3:L;NetFirms!B3:L;’Nuvei-Donation’!B3:L;’Nuvei-Retail’!B3:L;TechSoup!B3:L}, “select * where Col1 is not null or Col2 is not null or Col3 is not null or Col4 is not null or Col5 is not null or Col6 is not null or Col7 is not null or Col8 is not null or Col9 is not null or Col10 is not null or Col11 is not null”,0)