Excel, SAP, Oracle & automation tips — plus wacky facts
Final project: keep only the latest revision of each invoice, compute GST and build an HSN-wise summary for GSTR-1 style reporting, refreshable every month.
Read article →Turn a report with merged Region headers over Month headers into a clean table: transpose, fill down, combine header rows, unpivot and split.
Read article →A plain-English map of Oracle EPM Cloud: what Planning, Financial Consolidation and Close, Account Reconciliation, Narrative Reporting and EDM each do — and how…
Read article →Write a custom M function that skips junk header lines, promotes headers and sets types, then apply it to every file in a folder…
Read article →Write custom columns in M: proper-case names, 10-digit Indian mobile numbers, PIN codes and amounts from text like "Rs. 2,250", with try ... otherwise…
Read article →Keep the latest credit limit per customer with Group By, All Rows and Table.Max, count changes, and restore column types after expanding records.
Read article →Match "Sharma Trader", "Mehta and Sons" and "sharma traders" to the right master record with fuzzy merge, and tune the similarity threshold.
Read article →Match your books with the bank statement: build a matching key, find entries missing on either side with XLOOKUP, handle duplicates with COUNTIFS and…
Read article →Use Left Anti and Right Anti merges to find invoices with no payment and payments with no invoice, and know when to use each…
Read article →Turn a Tally day book or ledger export into a clean table: remove header clutter, split Dr and Cr amounts, fill ledger names down…
Read article →Stop editing ten queries when the file moves: read the folder path from a named cell or a parameter, and filter with typed dates.
Read article →DCOUNTA counts non-blank entries in a field for records that meet the criteria; unlike DCOUNT it also counts text. Like all D-functions it uses…
Read article →
