Excel’s FILTER Function: The #CALC! Mistake Nobody Explains
FILTER’s #CALC! and #SPILL! errors look similar but mean opposite things: one is about nothing matching, the other is about matches with nowhere to land.
How-To Guides
Step-by-step guides for the software and systems people actually use at work.
How to Unhide Rows in Excel (Row 1 Never Works the Normal Way)
The normal right-click method needs a visible row on both sides of the hidden one. Row 1 has no row above it, which is exactly why it needs a different fix.
Index Match Excel: The Real Reason It Survives a Column Insert
VLOOKUP trusts a number typed once and never rechecked. INDEX/MATCH searches for the column by name every time, which is the specific reason it survives an inserted column and VLOOKUP doesn’t.
XLOOKUP vs VLOOKUP: The Real Difference Nobody Mentions
XLOOKUP searches any direction and defaults to exact match. It’s also completely absent from Excel 2016 and Excel 2019, a compatibility gate most comparisons skip entirely.
The VLOOKUP Mistake That Breaks a Column With No Error
VLOOKUP’s col_index_num is a number typed once and never rechecked. Insert a column anywhere inside the range, and it silently returns the wrong value with no error at all.
Locking Down Gemini: The Admin Controls That Actually Matter
Vault overrides everything else on this list, but only for the surface it actually covers. A working checklist for every admin control that governs Gemini, in the order that avoids the two known gaps.
Gemini Notebook Copies Your Files Outside Your Org’s Rules
Revoking someone’s access to a Drive file doesn’t remove the copy they already pulled into a Gemini Notebook. The access check happens once, at import, and Google says so directly.
Deleting a Gemini Chat Doesn’t Delete It, If It’s on Hold
A deleted Gemini chat under hold looks identical to one that’s actually gone. Plus why the temporary chat and self-deletion privacy toggles are completely overridden the moment Vault is active.
Google Vault Doesn’t Cover Most of Gemini
A legal team asking to hold ‘all Gemini activity’ is describing something broader than what a Vault retention rule for the Gemini app actually reaches. The exact documented scope, and what falls outside it.
Why Writing Tools Doesn’t Work in WhatsApp
A missing feature in one app looks like Apple restricted it. The actual mechanism runs the other way: a shared system framework, adopted app by app, at each developer’s own pace.