Google Spreadsheets

How To Add Multiple Columns to Google Spreadsheets

I recently ran into this problem when I was looking at someones Adwords account and wanted to get an idea about all the unique keywords that they were using.  I used the following formula to get an array of all unique keywords: =UNIQUE(SPLIT(CONCATENATE(‘Keyword Report’!B2:B),” “)) But then I encountered a problem: “Error Result was not automatically […]

How To Add Multiple Columns to Google Spreadsheets Read More »

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets

Update: This script now allows you to copy multiple sheets within one spreadsheet to either the same spreadsheet or a different one. If you want to copy the sheet to the same spreadsheet, just input your current spreadsheet’s ID when prompted. The spreadsheet id can be found in the Spreadsheet’s URL eg: docs.google.com/spreadsheets/d/SPREADSHEETID/edit#gid=0 If you are looking

Bulk Hide, Show, Delete & Copy Multiple Sheets in Google Spreadsheets Read More »