Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

Tutorials

Create a Column of Random Numbers

June 12, 2024August 17, 2022 Adam Steinfurth

Learn several methods to generate a column of random numbers.

Categories Tutorials Tags arrayformula, COUNTA, int, rand, randarray, random

Summarize Unique Values In Google Sheets

November 1, 2024July 14, 2022 Adam Steinfurth

Learn how to list, count, and sum unique values from a table of data.

Categories Tutorials Tags COUNTIF, pivot table, query, SUMIF

Count Unique Values Regardless of Capitalization – Google Sheets

May 11, 2023June 29, 2022 Adam Steinfurth

Count unique values in a spreadsheet while ignoring capitalization.

Categories Tutorials Tags arrayformula, case insensitive, case sensitive, count, proper, unique

Count With OR Logic in Google Sheets

October 30, 2025May 31, 2022 Adam Steinfurth

Count cells based on several conditions

Categories Tutorials Tags arrayformula, count, COUNTIF, or, query

3 Google Sheets Formulas for No-Code App Builders

October 25, 2023May 27, 2022 Adam Steinfurth

Learn three must-know formulas for no code app builders.

Categories Tutorials Tags arrayformula, importrange, named range, query
Older posts
Newer posts
← Previous Page1 … Page16 Page17 Page18 … Page21 Next →

Keep your data sorted automatically

StaySorted moving a row automatically

Install StaySorted

Join over 30,000 users

  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2026 Sheets Help • Built with GeneratePress