Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Let’s Talk 💬
  • Add-Ons

arrayformula

RANK Function – Google Sheets

December 31, 2023November 1, 2023 Adam Steinfurth

Learn how to use the RANK function in Google Sheets to show the order of amounts.

Categories Statistical Tags arrayformula, order, rank

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

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

September 21, 2023May 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
Page1 Page2 Next →
StaySorted moving a row automatically

Get the Google Sheets Add-On
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress