Playground

Teach Biscuit a new trick.

Type what you need, Biscuit fetches it. Six real examples are sitting below if you want to watch him work first.

Describe it in plain English

Works with Excel Google Sheets VBA Regex Airtable Notion

No account needed. First five a day are free. Keep going with a pack.

Good boy in action

Or watch Biscuit fetch these first.

Six real requests, six working formulas. No hand waving.

01 · Count matches

"How many rows in column A contain the word 'Denver'?"

=COUNTIF(A:A, "*Denver*")

Wildcards do the heavy lifting.

02 · Running total

"Give me a running total of column B starting from row 2"

=SUM($B$2:B2)

The anchor is doing all the work.

03 · Match and return

"Get the price of a product from another sheet using its SKU"

=INDEX(Products!B:B, MATCH(A2, Products!A:A, 0))

Biscuit prefers INDEX/MATCH to VLOOKUP. It behaves better with column insertions.

04 · Parse a date

"Extract the month name from a date in column A"

=TEXT(A2, "mmmm")

Works in Excel and Google Sheets.

05 · Clean text

"Clean up text: strip extra spaces, title case"

=PROPER(TRIM(A2))

TRIM removes double spaces too, not just leading and trailing.

06 · Conditional color (VBA)

"Highlight cells in column C where the value is negative, in red"

Sub HighlightNegatives()
  Dim c As Range
  For Each c In Range("C:C").SpecialCells(xlCellTypeConstants, 1)
    If IsNumeric(c.Value) And c.Value < 0 Then
      c.Interior.Color = RGB(229, 73, 45)
    End If
  Next c
End Sub

Run it once, or save it as a macro.

No logins. No emails. Just formulas.

Five free formulas a day, on the house. Want more? A pack of 100 is $5 once, or $8/mo for the bottomless bowl. That's the whole menu.

← Back to the kennel See the bowls

If Biscuit got something wrong, tell him on the contact page. He is still learning some edge cases.