Pivot without the pivot
Prompt "Average sales by region"
=AVERAGEIFS(Sales[Amount], Sales[Region], A2)
Structured table references. Clean. No pivot table required.
🐶 formula.dog · since 2022
Good boy. Fetches formulas.
Describe your spreadsheet problem in plain English. Biscuit trots back a few seconds later with a working Excel or Google Sheets formula. First five a day are free, no sign up. He knows VBA too, macros don't scare him.
Live from the kennel
Watch Biscuit work.
You say what you need, Biscuit fetches the formula, you paste it. That's the loop.
You say
How do I sum column B only when column A is this week?
Biscuit says
=SUMIFS(B:B, A:A, ">="&TODAY()-WEEKDAY(TODAY(),3)+1, A:A, "<="&TODAY()+(7-WEEKDAY(TODAY(),3)))
This one sums values in column B only when the date in column A falls in
the current ISO week (Monday to Sunday). Good boy.
*fetches* =SUMIFS(...) *delivers it to your face*
Recent fetches
A few things Biscuit has fetched recently.
Three real examples, straight from the bowl.
Regex without tears
Prompt "Extract email from messy cell"
=REGEXEXTRACT(A2, "[a-zA-Z0-9._+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]+")
Works in Google Sheets. For Excel, Biscuit has a different treat.
VBA snack
Prompt "Hide all sheets except the active one"
Sub HideOthers()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> ActiveSheet.Name Then
ws.Visible = xlSheetHidden
End If
Next ws
End SubYes, VBA too. The old-school stuff still runs a lot of offices.
Tricks he knows
What Biscuit does.
- Excel formulas (including LET, LAMBDA, array formulas)
- Google Sheets (including ARRAYFORMULA, QUERY)
- VBA snippets for the old guard
- Regex helpers that actually match the thing
- Airtable and Notion formulas (basic support)
Not his thing
What Biscuit won't do.
- Power Query (he's still learning)
- Power BI DAX (different beast)
- Python or R (not his thing)
- Pretend to be a "spreadsheet productivity ecosystem"
- Ask for your email before showing you a formula
Treats and bowls
Pricing, plain as kibble.
Start free. Upgrade when Biscuit has earned his biscuits.
$0 forever
- 5 formulas a day
- No account required
- Excel, Sheets, VBA, Regex
$5 once
- 100 formulas, never expires
- All formats, no limits
- No subscription
$8 / month
- Unlimited formulas
- History and bookmarks
- Cancel anytime
No annual discounts. No enterprise sales calls. Just Biscuit.
2.1M
formulas fetched
38
kinds of spreadsheet software supported
1
very good dog
0
sales emails sent
Biscuit is ready. Give him something to chase →