Facebook Pinterest Twitter
  • Google Sheets
  • Forms
  • Docs
  • Excel
  • Sheets Vs. Excel
Search
InfoInspired InfoInspired InfoInspired
  • Google Sheets
    • 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…

      Example of how to get the fastest time for each person in Google Sheets

      How to Get the Fastest Time for Each Person in Google…

      Example of highlighting the smallest N values in each column in Google Sheets

      Highlight the Smallest N Values in a Column in Google Sheets

      Sorting pie slices with aggregating data

      How to Sort Pie Slices in Google Sheets

      Example of Filtering Names Unique to Groups in Google Sheets

      Filter Items Unique to Groups in Google Sheets

  • 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
    • 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)

      Extract the last N non-blank rows in Excel dynamically

      How to Extract the Last N Non-Blank Rows in Excel Dynamically

  • 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 Named Functions

Tag: Named Functions

FLIP Function Preview: Syntax and Description in Google Sheets

FLIP in Google Sheets – Custom Named Function to Reverse Data

Prashanth KV 0

Create Custom Time Slot Sequences in Google Sheets

Prashanth KV 0
SPLIT_EXPENSE named function used to split group expenses in Google Sheets with structured input and output

Array Formula to Split Group Expenses in Google Sheets

Prashanth KV 0
_3D Named Function in Google Sheets

3-D Reference in Google Sheets (Workaround)

Prashanth KV 2
Copy Clock Out to Clock In Row in Sheets

Copy Punch Out to the Punch In Row in Google Sheets...

Prashanth KV 0
COPY_TO_MASTER_SHEET Named Function Google Sheets

Combine Data Dynamically in Multiple Tabs Vertically in Google Sheets

Prashanth KV 0

Compare All Columns with Each Other for Duplicates in Google Sheets

Prashanth KV 0

Get the Next Renewal Date in Google Sheets (Monthly and Yearly)

Prashanth KV 0

AGE_CALC – A Named Function to Calculate Age or Duration in...

Prashanth KV 0
REPT_ROWS Named Function - Google Sheets

REPT_ROWS Named Function to Repeat Rows in Google Sheets

Prashanth KV 2
12Page 1 of 2
  1. Prashanth KV on Lookup the Smallest Value in a 2D Array in Google SheetsApril 25, 2025
  2. quochoantran on Lookup the Smallest Value in a 2D Array in Google SheetsApril 24, 2025
  3. Prashanth KV on Sparkline Bar Chart Formula Options in Google SheetsFebruary 22, 2025
  4. aSh on Sparkline Bar Chart Formula Options in Google SheetsFebruary 22, 2025
  5. Prashanth KV on Date-Related Conditional Formatting Rules in Google SheetsFebruary 21, 2025