Excel, SAP, Oracle & automation tips — plus wacky facts
Unusual formula combinations that turn hours of manual work into one cell.
Unusual formula combinations that turn hours of manual work into one cell.
📄 35 articles⬇️ 35 with practice files🕒 Updated 26 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →Break “Mumbai-MH-400001” or comma lists into columns and rows with TEXTSPLIT, TEXTBEFORE and TEXTAFTER in Excel 365, and the TRIM/MID/SUBSTITUTE trick for older versions.
Read article →Number rows 1, 2, 3 automatically: ROW and SEQUENCE for clean lists, COUNTA to skip blank rows, SUBTOTAL/AGGREGATE so numbering stays 1-2-3 after filtering,…
Read article →Stack monthly or branch sheets into one live list with VSTACK and 3D references, drop blank rows with FILTER, tag each row with its…
Read article →Separate "Asha Kumari Sharma" into first, middle and last names with TEXTBEFORE/TEXTAFTER/TEXTSPLIT, older LEFT/FIND/MID formulas, Flash Fill and Text to Columns — and handle…
Read article →Pick the rate that was valid on a transaction date from a price history — XLOOKUP with match mode -1, LOOKUP, MAXIFS + INDEX…
Read article →Pull the numbers out of messy text like "INV-2026-0045", "Paid Rs 12,500 via UPI" or "Call 98765 43210" with TEXTJOIN+MID+SEQUENCE, REGEXEXTRACT, TEXTAFTER and Flash…
Read article →Use LET to name parts of long formulas and LAMBDA to create reusable custom functions like CLEANTEXT or FYEAR — saved in Name Manager,…
Read article →Get the top 5 values that meet a condition — and the rows behind them — with LARGE+IF, AGGREGATE, FILTER+SORT+TAKE and SORTBY, in old…
Read article →Share of total, growth vs last month, contribution by region and year-on-year change — the correct formulas, absolute references, handling zero and blank values,…
Read article →Turn a daily sales list into month-wise totals: SUMIFS with EOMONTH date bounds, a month-by-region grid, TEXT month keys, pivot grouping and the new…
Read article →Sum or count the last 7 or 30 days with SUMIFS and TODAY(), build a 7-day moving average, a trailing-12-month total, and a rolling…
Read article →Find "Raj Traders Pvt Ltd" when you only typed "Raj", look up codes that start with a prefix, and sum or count rows that…
Read article →
