Brought to you by:

Hi Reader,

Welcome to the Google Sheets Tips newsletter #352, your Monday morning espresso, in spreadsheet form!

If you're a parent, then you've undoubtedly watched a lifetime's worth of Disney movies. You can appreciate the genius storytelling, rich characters and beautiful visuals. (But I'm sure you'd also be content to watch a film once, not 10 times!)

Anyway, there's a scene in the Disney film Ratatouille where Remy bites into a strawberry and a piece of cheese at the same time.

Fireworks go off.

And Remy realizes that the two ingredients combine to create a wonderful new flavor.

A whole-is-greater-than-the-sum-of-the-parts moment.

Functions in Google Sheets can be like that too.

Great alone, but even better, and more powerful, when combined together.

In today's newsletter, we're going to combine CHOOSECOLS (which we featured last week) with the versatile SEQUENCE function. Check it out below.

➜ News

I.
​I published a new AI + Sheets video that uses the new AI formula and Apps Script to turn Google Sheets data into draft emails in Gmail.

​

II.

Gemini in Google Sheets can now create editable charts!

​Read more here >>​

Brought to you by: Kirksville Web Design Premium Google Sites Templates 60+ awesome Google Sites templates with 60,000+ downloads. Google Sites is a no-code site builder with free hosting in Google Drive. Drag and drop your content into professionally designed themes, connect your own domain and hit publish. Use Google Sites for: Company intranets Team sites Wikis Small business websites Shop Now

➜ Sheets Tip #352: CHOOSECOLS + SEQUENCE = 🤩

​Last week, we looked at CHOOSECOLS and saw how you can use positive and negative integers to select columns from the left or right side of ranges.

Today, I want to show you another tip for using CHOOSECOLS.

Suppose we have a huge dataset, with hundreds of columns. And we want to select the first 20 columns. Or we want to select 10 columns in the middle, starting from the 11th column.

We can nest the versatile SEQUENCE function inside CHOOSECOLS, to save writing out the column numbers by hand.

For example,

generates a list of numbers from 1 to 20, i.e. 1, 2, 3, 4, 5, etc.

Whereas,

generates a list of 10 numbers starting from 11, i.e. 11, 12, 13, 14, etc.

We can nest SEQUENCE functions like these inside CHOOSECOLS, instead of writing the column numbers individually.

For example,

will select the first 20 columns. It's a shorthand equivalent to writing this:

Best of all, we can mix-and-match last week's tip and this week's tip to have complete control over the columns we want to select.

For example,

selects the first column, columns 11 to 20, and the last column.

Some functions are better together!

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. As someone in my mid-forties, this is very relatable.​