Griddy Blog
Practical spreadsheet notes.
Guides for formulas, cleanup, charts, and the spreadsheet work people actually get stuck on.
Page 2 of 11 · 128 posts
How to Fix the #NUM! Error in Excel
The #NUM! error in Excel means a formula produced an invalid number. Learn how to fix impossible inputs, overflow, and iteration issues.
Why SUMIF Is Not Working in Excel
SUMIF may fail when ranges do not match, criteria are typed incorrectly, or source data is dirty. Learn how to debug it.
Why VLOOKUP Returns the Wrong Value in Excel
VLOOKUP can return the wrong value when match mode, column indexes, duplicates, or dirty lookup keys are off. Learn the fixes.
Employee Leave Tracker in Excel
Build an employee leave tracker in Excel that keeps PTO balances, upcoming absences, approval status, and staffing coverage visible.
How to Build a PTO Calendar in Excel
Build a PTO calendar in Excel that shows approved leave by date while keeping balances and coverage notes connected to the tracker.
How to Manage Time-Off Requests in a Spreadsheet
Manage time-off requests in a spreadsheet with clear statuses, PTO balances, approval notes, and coverage checks before the schedule changes.
PTO Tracker Template for Excel
A PTO tracker template in Excel should show balances, approved leave, return dates, and coverage notes without becoming an HR system.
How to Fix the #SPILL! Error in Excel
The #SPILL! error in Excel means a dynamic array formula cannot expand. Learn how to clear the spill range and fix the formula.
How to Fix the #DIV/0! Error in Excel
The #DIV/0! error in Excel means a formula is dividing by zero or a blank cell. Learn when to fix the data and when to add a safe fallback.
How to Fix the #REF! Error in Excel
The #REF! error in Excel means a formula points to a missing cell or range. Learn the common causes and the cleanest ways to repair it.
How to Fix the #VALUE! Error in Excel
The #VALUE! error in Excel usually means a formula received the wrong data type. Learn how to find the cause and repair the formula.
How to Highlight Duplicates in Excel
Highlight duplicates in Excel with conditional formatting, formulas, and cleaner review rules. Learn how to spot repeated IDs, emails, invoices, and names.