Reconciler
Select a range of transactions and a target value. The reconciler finds every combination of entries that adds up to your target — highlighting candidates in yellow and showing how many options exist.
Cycle through options with one click; undo restores the sheet cleanly.
Aggregate by Colour
Point at any cell as a colour reference and choose SUM, AVERAGE, MAX, or MIN. tech+bash aggregates every cell in your range that matches that fill colour — no helper columns, no formulas to maintain.
Insert the result directly into any cell on the sheet.
Colour-coded spreadsheets are everywhere in accounting. This is the only way to aggregate them without resorting to VBA or manual selection.
The TB Namespace
Formulas Excel should have built in. Access them via =TB. autocomplete or through the Formulas tab under the tech+bash category.
- TB.STATICRANDBETWEEN — a random number that doesn’t recalculate on every change
- TB.GROSSUP — net to gross in one formula
- TB.GROSSDOWN — gross to net in one formula
Ready to save time?
Works in Excel Desktop and Excel Online. No setup beyond the add-in install.
