Facebook Pinterest Twitter
  • Google Sheets
  • Forms
  • Docs
  • Excel
  • Sheets Vs. Excel
Search
InfoInspired InfoInspired InfoInspired
  • Google Sheets
    • Example of a formula returning semimonthly dates in Google Sheets

      How to Generate Semimonthly Dates in Google Sheets

      Google Sheets: Get the Last Row with Any Data Across Multiple…

      Example of calculating digital root in Google Sheets

      How to Calculate Digital Root in Google Sheets

      Book reading summary dashboard in Google Sheets

      How to Build an Advanced Book Tracker in Google Sheets: Formulas…

      Overview of the Google Sheets Reading List Tracker Template

      Google Sheets Reading List Tracker Template (Free Download)

  • Forms
    • Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

      Automatically Pre-fill Google Forms from Google Sheets: A Step-by-Step Guide

      How to Set Up Google Docs Forms: A Comprehensive Guide

  • Docs
    • Example showing how to make just one page landscape in Google Docs with surrounding pages in portrait mode

      How to Make Just One Page Landscape in Google Docs

      How to Insert Drop-downs in Google Docs Documents

      How to Create a Table and Pin and Unpin Header Rows…

      How to Use Section Break in Google Docs

      google docs doc writer table

      How to Split a Table in Google Docs

  • Excel
    • Mode of Comma-Separated Numbers in Excel (Dynamic Array)

      Example showing how to sort each row individually in Excel using a LAMBDA formula

      Sort Each Row Individually in Excel Using a LAMBDA Formula

      Sort data by field label selected from a drop-down list in Excel

      Sort by Field Labels Using the SORT and XMATCH Combo in…

      Example of inserting two blank rows in a table in Excel

      Dynamic Way to Insert Blank Rows in a Table in Excel

      Example of inserting empty cells between values in a column in Excel using a dynamic array formula

      Insert N Empty Cells Between Values in Excel (Dynamic Array)

  • Sheets Vs. Excel
    • Running total resets by category using SCAN

      Reset SCAN by Another Column in Google Sheets and Excel

      Spreadsheet example of maximum drawdown calculation

      How to Calculate Maximum Drawdown in Excel and Google Sheets

      Lookup previous values dynamically in Excel or Google Sheets

      Lookup Previous Values Dynamically in Excel and Google Sheets

      Formula example for sorting data while keeping blank rows intact (Excel and Google Sheets)

      Sort Data but Keep Blank Rows in Excel and Google Sheets

      Example of looking up values under categories in Excel using XLOOKUP and VLOOKUP functions

      Lookup Values Under Categories in Excel and Google Sheets

Home Tags Spreadsheet

Tag: Spreadsheet

Google Sheets IFERROR Function: Everything You Need to Know

Prashanth KV 1
Index Match - Better Alternative to Vlookup and Hlookup

INDEX-MATCH: Better Alternative to VLOOKUP and HLOOKUP in Google Sheets

Prashanth KV 16

Master the IF Function in Google Sheets: Beyond the Basics

Prashanth KV 8

Pick a Random Name from a Long List in Google Sheets

Prashanth KV 14

INDEX Function in Google Sheets: Dynamic Range Techniques

Prashanth KV 4

How to Use the MATCH Function in Google Sheets

Prashanth KV 2

RAND and RANDBETWEEN Functions in Google Sheets

Prashanth KV 0

Frequency of Recalculation for Volatile Functions in Google Sheets

Prashanth KV 0

How to Use Curly Brackets to Create Arrays in Google Sheets

Prashanth KV 12

How to Use the RANK Function in Google Sheets

Prashanth KV 0
1...129130131...139Page 130 of 139
  1. Christos on Finding Current Win/Loss Streak in Google SheetsJune 17, 2025
  2. Prashanth KV on Finding Current Win/Loss Streak in Google SheetsJune 17, 2025
  3. Christos on Finding Current Win/Loss Streak in Google SheetsJune 17, 2025
  4. Prashanth KV on Multiple-Selection Dependent Drop-Downs in Google SheetsMay 30, 2025
  5. Quan on Multiple-Selection Dependent Drop-Downs in Google SheetsMay 29, 2025