THE SPENDIXAI JOURNAL

Make room for
better money habits.

Thoughtful guides for everyday spending. Practical examples, clear explanations and ideas you can put to work.

READ. UNDERSTAND. PUT IT INTO PRACTICE.Original guides · SpendixAI Editorial

Find your next good read.

Small decisions. Clearer thinking. A useful place to start.

Clear

599 guides · Page 15 of 50

Take your time. Find what helps.
Editorial illustration for Extract a merchant name from a UPI narration with LEFT, MID, FIND
Spreadsheets 4 min read

Extract a merchant name from a UPI narration with LEFT, MID, FIND

Pull the payee name out of a slash-separated UPI narration in Excel with FIND, MID, TRIM and IFERROR, using a checked worked example you can copy.

Read article
Editorial illustration for Extract the UPI reference number from a narration column
Spreadsheets 3 min read

Extract the UPI reference number from a narration column

Extract the UPI reference number from a narration column in Excel with MID and FIND or Flash Fill, and store it as text so no digits are lost.

Read article
Editorial illustration for Fill down missing dates in statement rows where the date is blank
Spreadsheets 4 min read

Fill down missing dates in statement rows where the date is blank

Fill blank dates in statement rows with the date above using Go To Special, a helper formula or Power Query Fill Down, and avoid the traps that wreck data.

Read article
Editorial illustration for Fill missing months so a time-series chart has no gaps
Spreadsheets 4 min read

Fill missing months so a time-series chart has no gaps

Months with no transactions vanish from pivots and charts. Build a full month list and SUMIFS against it so zeros show and the time axis stays even.

Read article
Editorial illustration for FILTER function: show only one month of expenses in Excel 365
Spreadsheets 3 min read

FILTER function: show only one month of expenses in Excel 365

Show one month of expenses with the FILTER function in Excel 365, driven by month and year input cells, with a friendly message for months without data.

Read article
Editorial illustration for FILTER in Google Sheets by category and month
Spreadsheets 4 min read

FILTER in Google Sheets by category and month

Filter expenses in Google Sheets by category and month with one FILTER formula, using multiplied conditions, a date range and an All option.

Read article
Editorial illustration for Financial year column (April to March) from a date in Excel
Spreadsheets 3 min read

Financial year column (April to March) from a date in Excel

Build a financial year column from a date in Excel for April to March, with a start-year formula, a 2024-25 label and a quarter number for filtering.

Read article
Editorial illustration for A financial-year selector dropdown for your expense dashboard
Spreadsheets 4 min read

A financial-year selector dropdown for your expense dashboard

Add a financial-year dropdown to an expense dashboard: list years like 2025-26 with UNIQUE, then feed start and end dates into every SUMIFS on the sheet.

Read article
Editorial illustration for Find duplicate entries in an expense sheet using COUNTIFS
Spreadsheets 4 min read

Find duplicate entries in an expense sheet using COUNTIFS

Find duplicate entries in an expense sheet with a COUNTIFS helper column, highlight them with conditional formatting and delete the extras safely.

Read article
Editorial illustration for Find duplicate transactions in Excel with COUNTIFS
Spreadsheets 3 min read

Find duplicate transactions in Excel with COUNTIFS

Find duplicate transactions in Excel with a COUNTIFS helper column on date, amount and merchant, and tell a genuine double charge from two real purchases.

Read article
Editorial illustration for Find hidden rows and columns in a downloaded statement file
Spreadsheets 4 min read

Find hidden rows and columns in a downloaded statement file

Find hidden rows and columns in a downloaded statement file, unhide them and check your totals against the statement so no transaction goes missing.

Read article
Editorial illustration for Find missing months in a set of statements before you analyse them
Spreadsheets 3 min read

Find missing months in a set of statements before you analyse them

Spot missing months in your statements with a COUNTIFS grid, a date-gap formula and a balance-chain check before incomplete history misleads your analysis.

Read article