Formulas Biscuit fetches most often

Count rows matching a condition

Returns the number of cells in column A that exactly match "Denver".

Count with a wildcard

Uses asterisks for partial matches. Works in Excel and Google Sheets.

Count with multiple conditions

Every condition-range pair is AND. For OR logic, add two COUNTIFS.

Sum only matching rows

Sums the values in column B where column A equals "Denver".

Sum with multiple conditions

The value-range goes first in SUMIFS, then the condition pairs. Easy to flip by accident.

Running total

Drag down. The anchor locks the start, the relative end grows as you go.

Basic VLOOKUP

Finds A2 in Products column A, returns the 3rd column. FALSE means exact match.

INDEX/MATCH (better)

Biscuit prefers this. It handles column insertions and looks left.

XLOOKUP (newer Excel)

The modern replacement. Cleaner, handles errors better. No Google Sheets support yet.

Approximate match (sorted data)

TRUE means find the largest value less than or equal to A2. Useful for tax brackets.

Two-way lookup

Row and column both matched dynamically.

Strip whitespace

Removes leading, trailing, and duplicate internal spaces.

Title case

"hello world" becomes "Hello World".

Concatenate with separator

The TRUE ignores blanks.

Extract domain from email

FIND locates the @, MID takes everything after it.

Regex extract (Google Sheets)

Pulls the first email address out of any mess.

Regex replace

Collapses all whitespace to single spaces.

Today's date

Updates every time the sheet recalculates.

Days between two dates

Dates are numbers under the hood. Subtraction just works.

Month name from a date

Returns "January", "February", etc.

First day of current month

EOMONTH is "end of month". Go back one month, add one day.

Start of ISO week (Monday)

WEEKDAY with type 3 returns 0 for Monday, so subtracting it lands on Monday.

Working days between dates

Excludes Saturdays, Sundays, and optional holidays.

Apply a formula to a whole column

No more dragging down thousands of rows.

QUERY with SQL-like syntax

Pretend you're writing SQL. It actually works.

FILTER

Returns matching rows. No ugly array formula tricks needed.

UNIQUE

Returns every distinct value in column A. Sorts as found, not alphabetically.

SORT

Sorts by the second column, descending.

Hide all sheets except active

Sub HideOthers()
  Dim s As Worksheet
  For Each s In ThisWorkbook.Worksheets
    If s.Name <> ActiveSheet.Name Then s.Visible = xlSheetHidden
  Next s
End Sub

Quickly collapse a workbook down to whatever you're actually working on.

Remove empty rows in used range

Sub KillEmpties()
  Dim r As Long
  For r = ActiveSheet.UsedRange.Rows.Count To 1 Step -1
    If Application.CountA(Rows(r)) = 0 Then Rows(r).Delete
  Next r
End Sub

Walks backwards so row numbers don't shift as you delete.

Open every file in a folder

Sub LoopFolder()
  Dim f As String
  f = Dir("C:\path\to\folder\*.xlsx")
  Do While f <> ""
    Workbooks.Open "C:\path\to\folder\" & f
    f = Dir()
  Loop
End Sub

Classic Dir loop. Perfect when you have a folder full of monthly reports.