Facebook Pinterest Twitter
  • Google Sheets
  • Forms
  • Docs
  • Excel
  • Sheets Vs. Excel
Search
InfoInspired InfoInspired InfoInspired
  • Google Sheets
    • Mode of Comma-Separated Numbers in Google Sheets

      How to Find Mode of Comma-Separated Numbers in Google Sheets

      Example showing the count of merged cells in a column in Google Sheets using a formula

      How to Count Merged Cells in Google Sheets (and Get Their…

      Count consecutive workday absences in Google Sheets using a formula that skips weekends and holidays

      Count Consecutive Workday Absences in Google Sheets

      Stacked bar chart in Google Sheets visualizing top N sellers for top N products using chart-ready formula output

      Top N Products and Top N Sellers in Google Sheets (Top…

      Using ARRAYFORMULA with XLOOKUP to apply lookup to entire structured column in Google Sheets

      Use XLOOKUP in a Structured Table in Google Sheets (Single and…

  • 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
    • How to Insert Drop-downs in Google Docs Documents

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

      Docs Section Break - Margin, Header/Footer, and Page Numbering

      How to Use Section Break in Google Docs

      google docs doc writer table

      How to Split a Table in Google Docs

      How to Create First Line Indent and Hanging Indent in Google…

  • 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

Running total using structured table references in Google Sheets - array formula

Running Total with Structured Table References in Google Sheets

Prashanth KV 0
Example of a multi-colored line chart in Google Sheets showing increasing and decreasing trends

Automate Multi-Colored Line Charts in Google Sheets

Prashanth KV 0
Calculating the number of nights in each month for multiple check-in and check-out date records in Google Sheets

Calculate the Number of Nights in Each Month in Google Sheets

Prashanth KV 0
Example of Extracting the First Text Value in a Range in Google Sheets

Get the First Text Value in a Range in Google Sheets

Prashanth KV 0
Example of Extracting the First Numeric Value in a Range in Google Sheets

Get the First Numeric Value in a Range in Google Sheets

Prashanth KV 0

How to Create a Case-Sensitive Pivot Table in Google Sheets

Prashanth KV 0
Sample Data and Highlighting of Upcoming Birthdays in 30 Days

Highlight Upcoming Birthdays in Google Sheets

Prashanth KV 0
Calculated field for weighted average in the Pivot Table

Calculate Weighted Average in Pivot Table in Google Sheets

Prashanth KV 0
Example of summarizing data by Name and Month and retaining the last record in Google Sheets

Summarize Data and Keep the Last Record in Google Sheets

Prashanth KV 0
Filter data using multi-select drop-down chips in Google Sheets for dynamic filtering

Filter Data Using a Multi-Select Drop-Down in Google Sheets

Prashanth KV 0
1...345...138Page 4 of 138
  1. Tuukka on Relative Cell Reference in Importrange in Google SheetsMay 19, 2025
  2. celes on Hyperlink to Jump to Current Date Cell in Google SheetsMay 14, 2025
  3. Prashanth KV on Lookup the Smallest Value in a 2D Array in Google SheetsApril 25, 2025
  4. quochoantran on Lookup the Smallest Value in a 2D Array in Google SheetsApril 24, 2025
  5. Prashanth KV on Sparkline Bar Chart Formula Options in Google SheetsFebruary 22, 2025