Rank in Excel: Handle Ties and Rank Within Each Group
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 →Excel, SAP, Oracle & automation tips — plus wacky facts
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 →Answer “what would it take?” questions in Excel: Goal Seek for break-even units, target price and affordable loan; one- and two-variable Data Tables for…
Read article →ARABIC reads Roman numerals so you can sort “Part IX” correctly after “Part VIII”.
Read article →Make SAP scripts robust: loop over a list of company codes, export ALV lists to a file, check for popups and status-bar messages, and…
Read article →UNICHAR returns a character from its Unicode number — arrows, ticks, the rupee sign — without hunting through Insert › Symbol.
Read article →Read a recorded SAP script: the application-connection-session objects, findById paths, text, press and sendVKey, and how to replace hard-coded values with variables.
Read article →Understand SAP GUI scripting: what it can automate, server and client settings (sapgui/user_scripting), security prompts, and when to use it versus BAPIs or standard…
Read article →MathLevel: BeginnerAvailable in: Excel 2007+ROMAN turns 1–3999 into Roman numerals — chapter numbers, annual-report years.Syntax=ROMAN(number.
Read article →A practical comparison of VLOOKUP, XLOOKUP and INDEX-MATCH in Excel — when each one works, when it breaks, and which to use in 2025.
Read article →CHAR returns the character for a code number. CHAR(10) is a line break — the key to multi-line cells built by formula. CODE does…
Read article →UNICODE returns the code point of the first character. Unlike CODE it is correct for Hindi, emoji and symbols.
Read article →LOWER converts all letters to lowercase — handy when comparing emails or usernames typed inconsistently.
Read article →You blink around 15–20 times a minute.
Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry eyes.