Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

array

SORT Function in Google Sheets

February 4, 2026January 31, 2026 Adam Steinfurth

Sort a range and output the dynamic results.

Categories Filter Tags array, filter, sort

How to Select Random Rows from a List in Google Sheets

September 4, 2025June 18, 2025 Adam Steinfurth

Learn how to select a random sample from a list in Google Sheets.

Categories Tutorials Tags add-on, array, random, random sampler

CHOOSEROWS Function – Google Sheets

September 4, 2025June 17, 2025 Adam Steinfurth

Learn how to use the CHOOSEROWS function in Google Sheets for selecting, reordering, and extracting specific rows from your data.

Categories Array Tags array, chooserows

INDEX Function – Google Sheets

October 10, 2023January 12, 2023 Adam Steinfurth

The INDEX function retrieves a value from a cell within a range.

Categories Lookup Tags array, index, lookup, match

Conditionally Count Unique Values in Google Sheets

August 8, 2024December 19, 2022 Adam Steinfurth

Three techniques to count unique values based on specified criteria.

Categories Tutorials Tags array, count, countuniqueifs, function, query, unique
Older posts
Page1 Page2 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