Skip to content

> Script Everything

  • Spreadsheets
  • Python
  • About

Spreadsheets

If there's one application I have come to appreciate more and more throughout my career it's the humble spreadsheet. Without this application, I would be lost.

I use this type of software every day and have been using it since 1995 and Microsoft Excel.

However, since working with Google Apps more frequently I've found I tend to do a lot more work with Google Sheets at work than Microsoft Excel. I have found the sharing and collaboration feature with Google Sheets a handy and powerful feature.

Google Sheets: 3 Ways To Reference Data In Another Sheet (Examples)

August 15, 2022 by Ryan Sheehy

How do you reference data in another sheet using Google Sheets? If you need to reference data in the same Google Sheet, there are two means: the sheet reference syntax using the name of the sheet followed by an exclamation mark and the range (i.e. “Sheet2!A1”), or the function called INDIRECT. If you need to …

Read more

Categories Google Sheets

Google Sheets HLOOKUP Function With Examples

August 13, 2022 by Ryan Sheehy

How do you use the HLOOKUP function in Google Sheets, and what are some best use cases? The HLOOKUP function searches for data in the first row of a range and returns a specific nth cell in the column found. HLOOKUP is an excellent function to use in data sets where the primary search needs …

Read more

Categories Apps , Google Sheets , Spreadsheets

How To Change Aggregate Name In Google Sheet QUERY Function (Examples)

August 9, 2022 by Ryan Sheehy

How do you change the default aggregate name created in Google Sheets when using the QUERY() function? To change the header label of an aggregate column from a QUERY() function append LABEL aggregate_column ‘YOUR LABEL’ to your SELECT statement. For example, if you had the following QUERY formula in your Google Sheet and you wanted …

Read more

Categories Google Sheets

How To Aggregate Data From Multiple Sheets With QUERY In Google Sheets

August 8, 2022 by Ryan Sheehy

How can you aggregate data using multiple sheets with the QUERY function in Google Sheets? To aggregate data sourced from multiple sheets, create a data set using the set notation {} by referencing each sheet then within the query statement of the QUERY function reference columns using ColX (with X being the index number of …

Read more

Categories Google Sheets

Concatenate Multiple Ranges Into One And Filter Using QUERY: Google Sheets (Example)

August 7, 2022 by Ryan Sheehy

How do you concatenate two ranges into one contiguous range for use in the QUERY function for the data parameter in Google Sheets? To concatenate two ranges into one for use as the first parameter in the QUERY function in Google Sheets, simply combine your data sets together using the set notation {} and the …

Read more

Categories Google Sheets

Google Sheets QUERY Function WHERE Reference To Cell Value: Examples

August 6, 2022 by Ryan Sheehy

How do you reference a cell in the WHERE clause of a Google Sheets QUERY function? To reference a cell in the Google Sheets’ QUERY function WHERE clause, simply break the query string by closing with a double-quoted string ” append the concatenation symbol & then reference the cell append the & to open up …

Read more

Categories Google Sheets

Conditional Formatting With Checkboxes In Google Sheets

August 1, 2022 by Ryan Sheehy

How can you apply conditional formatting on checkbox cells in Google Sheets? Conditional formatting in Google Sheets can be applied to a range of checkboxes by applying the conditional formatting condition of Is equal to to TRUE. Here’s an example demonstrating how to set a conditional format on checkboxes. Create Checkbox Range To create a …

Read more

Categories Google Sheets

How To Highlight Duplicates In A Range: Google Sheets Conditional Formatting

July 23, 2022 by Ryan Sheehy

How do you highlight duplicates in a defined range using conditional formatting in Google Sheets? To highlight cells that are the same value in a range, select the range and use a custom formula in the conditional formatting area that uses relative referencing. The custom formula you will want to insert into the conditional formatting …

Read more

Categories Google Sheets

REGEXEXTRACT Date From String In Google Sheets

July 8, 2022 by Ryan Sheehy

How can you extract a date from a string in a cell in Google Sheets using the powerful REGEXEXTRACT() function? The REGEXEXTRACT(text, regular_expression) function has two parameters with the first labelled as text being the string operated on and the second labelled as regular_expression being the regular expression (using RE2 syntax) to extract data from. …

Read more

Categories Google Sheets , Uncategorized

Apply Conditional Formatting To Entire Row: Google Sheets

June 17, 2022 by Ryan Sheehy

How can you highlight an entire row based on a single condition in another column? To highlight an entire row based on a value in a column using conditional formatting requires using the INDIRECT() formula. A spreadsheet contains the following simple data where the first column contains a list of dates and the other columns …

Read more

Categories Google Sheets
Older posts
Newer posts
← Previous Page 1 Page 2 Page 3 … Page 6 Next →
YouTube Twitter
  • Send A Message
  • Privacy Policy
© 2023 > Script Everything • Built with GeneratePress