Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

array

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

UNIQUE Function – Google Sheets

December 3, 2022 Adam Steinfurth

Remove duplicate lines from a table of data

Categories Filter Tags array, duplicates, filter, unique
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