Excel, SAP, Oracle & automation tips — plus wacky facts
Unusual formula combinations that turn hours of manual work into one cell.
Flag duplicate invoices, repeated customers and duplicate rows with COUNTIF/COUNTIFS, conditional formatting, UNIQUE and the first-occurrence trick — and choose what “duplicate” means before…
Read article →Get the latest price, last status or most recent date for an item with the famous LOOKUP(2,1/(range=value)) formula — explained step by step, plus…
Read article →Look up a value using two conditions — product AND region, or employee AND month — with XLOOKUP, INDEX-MATCH, or a helper column. With…
Read article →Which customers are in this month’s list but not last month’s? Compare two lists with COUNTIF, MATCH/XMATCH, FILTER and conditional formatting — in old…
Read article →Calculate weighted averages correctly — average price by quantity, weighted marks, blended interest rates — with SUMPRODUCT/SUM, weighted averages with conditions, and why plain…
Read article →Look up a value at the crossing of a row and a column — target for South in August, price for size L in…
Read article →Turn any date into the Indian financial year (April–March) like "FY 2026-27" or "FY27", the fiscal quarter Q1–Q4, the fiscal month number and FY…
Read article →Make a second drop-down that changes with the first: INDIRECT with named ranges for any Excel, and FILTER+UNIQUE dynamic lists for Excel 365, plus…
Read article →SUMPRODUCT multiplies arrays and adds the result — which makes it a multi-condition counter, a weighted average, a case-sensitive lookup and more, in every…
Read article →RANK.EQ vs RANK.AVG, unique ranks with no ties, dense ranking, and ranking within each region or month using COUNTIFS — with a leaderboard example…
Read article →VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for…
Read article →
