Skip to content
Sheets Help

Tips, tutorials, and training

  • Basics
  • Tutorials
  • Functions

array

INDEX Function – Google Sheets

January 26, 2023January 12, 2023 by Adam Steinfurth

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

Categories Lookup Tags array, index, lookup, match Leave a comment

Conditionally Count Unique Values in Google Sheets

December 31, 2022December 19, 2022 by Adam Steinfurth

Three techniques to count unique values based on specified criteria.

Categories Tutorials Tags array, count, countuniqueifs, function, query, unique Leave a comment

UNIQUE Function – Google Sheets

December 3, 2022 by Adam Steinfurth

Remove duplicate lines from a table of data

Categories Filter Tags array, duplicates, filter, unique 2 Comments

SORT Function in Google Sheets

November 30, 2022November 28, 2022 by Adam Steinfurth

Sort a range and output the dynamic results.

Categories Filter Tags array, filter, sort Leave a comment

RANDARRY Function – Google Sheets

August 17, 2022August 10, 2022 by Adam Steinfurth

The RANDARRAY function generates and array of random decimals.

Categories Math Tags array, randarray, random Leave a comment
Older posts
Page1 Page2 Next →

Makers of:

Insert Special Characters Add-On Icon Insert Special Characters

TripTally Logo TripTally

Google Sheets Basics – Create, Design, and Share

See the course
  • Home
  • Basics
  • Functions
  • Tutorials
  • About
  • Contact
© 2023 Sheets Help • Built with GeneratePress