Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas

🤯 Wacky fact of the day · Human Body

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…

Why? How? →Source ↗

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips — plus wacky facts

Skip to content
  • ✨ AI Helper
  • 🎓 Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact

Atul Vij

Rank in Excel: Handle Ties and Rank Within Each Group

Rank in Excel: Handle Ties and Rank Within Each Group featured illustration

10 Apr 2020 · Formula Combos · 2 min read

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 →
10 April 2020 by Atul Vij Formula Combos

Goal Seek and Data Tables: What-If Analysis in Excel

Goal Seek and Data Tables: What-If Analysis in Excel featured illustration

8 Apr 2020 · Excel Formulas · 4 min read

Goal Seek and Data Tables: What-If Analysis in Excel

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 →
8 April 2020 by Atul Vij Excel Formulas

ARABIC Function in Excel: Roman Numerals to Numbers

ARABIC Function in Excel: Roman Numerals to Numbers featured illustration

6 Apr 2020 · Excel Functions A–Z · 1 min read

ARABIC Function in Excel: Roman Numerals to Numbers

ARABIC reads Roman numerals so you can sort “Part IX” correctly after “Part VIII”.

Read article →
6 April 2020 by Atul Vij Excel Functions A–Z, Math & Trig

SAP GUI Scripting Lesson 5: Loops, Errors and Exports to Excel

SAP GUI Scripting Lesson 5: Loops, Errors and Exports to Excel featured illustration

5 Apr 2020 · SAP GUI Scripting · 2 min read

SAP GUI Scripting Lesson 5: Loops, Errors and Exports to Excel

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 →
5 April 2020 by Atul Vij SAP GUI Scripting

UNICHAR Function in Excel: Any Unicode Symbol

UNICHAR Function in Excel: Any Unicode Symbol featured illustration

3 Apr 2020 · Excel Functions A–Z · 1 min read

UNICHAR Function in Excel: Any Unicode Symbol

UNICHAR returns a character from its Unicode number — arrows, ticks, the rupee sign — without hunting through Insert › Symbol.

Read article →
3 April 2020 by Atul Vij Excel Functions A–Z, Text

SAP GUI Scripting Lesson 3: Understanding the Recorded VBScript

SAP GUI Scripting Lesson 3: Understanding the Recorded VBScript featured illustration

3 Apr 2020 · SAP GUI Scripting · 2 min read

SAP GUI Scripting Lesson 3: Understanding the Recorded VBScript

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 →
3 April 2020 by Atul Vij SAP GUI Scripting

SAP GUI Scripting Lesson 1: What It Is (and Permissions)

SAP GUI Scripting Lesson 1: What It Is (and Permissions) featured illustration

1 Apr 2020 · SAP GUI Scripting · 1 min read

SAP GUI Scripting Lesson 1: What It Is (and Permissions)

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 →
1 April 2020 by Atul Vij SAP GUI Scripting

ROMAN Function in Excel: Numbers to Roman Numerals

ROMAN Function in Excel: Numbers to Roman Numerals featured illustration

31 Mar 2020 · Excel Functions A–Z · 1 min read

ROMAN Function in Excel: Numbers to Roman Numerals

MathLevel: BeginnerAvailable in: Excel 2007+ROMAN turns 1–3999 into Roman numerals — chapter numbers, annual-report years.Syntax=ROMAN(number.

Read article →
31 March 2020 by Atul Vij Excel Functions A–Z, Math & Trig

XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?

XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?

23 Mar 2020 · Excel Formulas · 5 min read

XLOOKUP vs VLOOKUP vs INDEX-MATCH: Which One Should You Use?

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 →
23 March 2020 by Atul Vij Excel Formulas

CHAR Function in Excel: Character From a Code (Line Breaks, Symbols)

CHAR Function in Excel: Character From a Code (Line Breaks, Symbols) featured illustration

19 Mar 2020 · Excel Functions A–Z · 1 min read

CHAR Function in Excel: Character From a Code (Line Breaks, Symbols)

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 →
19 March 2020 by Atul Vij Excel Functions A–Z, Text

UNICODE Function in Excel: Unicode Number of a Character

UNICODE Function in Excel: Unicode Number of a Character featured illustration

16 Mar 2020 · Excel Functions A–Z · 1 min read

UNICODE Function in Excel: Unicode Number of a Character

UNICODE returns the code point of the first character. Unlike CODE it is correct for Hindi, emoji and symbols.

Read article →
16 March 2020 by Atul Vij Excel Functions A–Z, Text

LOWER Function in Excel: Convert Text to Small Letters

LOWER Function in Excel: Convert Text to Small Letters featured illustration

15 Mar 2020 · Excel Functions A–Z · 1 min read

LOWER Function in Excel: Convert Text to Small Letters

LOWER converts all letters to lowercase — handy when comparing emails or usernames typed inconsistently.

Read article →
15 March 2020 by Atul Vij Excel Functions A–Z, Text

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →