FILTER "No matches are found" #N/A in Google Sheets: two causes, read the tooltip first
=FILTER(...) comes back as #N/A. The key you wanted might be missing, or it might be sitting right...
Tag archive
=FILTER(...) comes back as #N/A. The key you wanted might be missing, or it might be sitting right...
If you work with weekly surveillance data, you know the drill. A line list lands in your inbox with...
We run about three hundred and forty fuel cards, one for each vehicle. Every month the fuel card...
After cancelling a subscription, log its expected next charge date and check your statement. This spreadsheet does not cancel services or send alerts.
Work out prorated rent for a mid-month move-in or move-out three common ways (actual days in the month, a 365-day year, and rent divided by 30), with exact formulas that handle 28-, 30- and 31-day months and a move-in and move-out in the same month.
You write =IMPORTRANGE(...) to pull a range from another spreadsheet and the cell shows #REF!. The...
Most Excel totals come from four functions: SUM, SUMIF, SUMIFS and SUBTOTAL. SUM adds a range, SUMIF...
Disclosure: Seller Sheets Lab sells the paid workbook linked at the end. This tutorial is a...
A restaurant menu is a small data model: ingredients with prices, recipes that use them, and dishes...
How to Reconcile Marketplace Sales, Fees, Refunds and Payouts in a Spreadsheet Disclosure:...
You paste a VLOOKUP from a tutorial and the cell shows #ERROR!. The tooltip says Formula parse error....
A monthly budget is easier to review when it answers four questions. How much came in? How much went...