Skip to content
OmidBI Logo – Expert in Power Query, Excel, and Business Intelligence Solutions

OmidBI

  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query
Schedule Tasks Using Dependencies
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Schedule Tasks Using Dependencies

Challenge No. 618: Today’s challenge is contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python.

January 5, 2026July 11, 2025
Find First Palintiple Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

Find First Palintiple Numbers

Challenge No. 617: Take a number n and reverse it to get a number r.
Solved using: Excel VBA.

January 4, 2026July 11, 2025
Rank Cities by Percent Change
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Rank Cities by Percent Change

Challenge No. 615: List the top 3 cities where sum of %change from 2020 to 2021 and 2021 to 2022 is the highest.
Solved using: Python.

January 3, 2026July 11, 2025
Count Consecutive Number Repeats
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Count Consecutive Number Repeats

Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.

January 3, 2026July 11, 2025
Generate Sum of Digits Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Generate Sum of Digits Sequence

Challenge No. 613: Sum of Digits Sequence – It starts with 1 and every succeeding term is sum of all digits appearing previously.
Solved using: Excel VBA.

January 2, 2026July 11, 2025
Match Names with Same Initials
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Match Names with Same Initials

Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.

January 2, 2026July 11, 2025
Find Maximum N-Digit Grid Number
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Find Maximum N-Digit Grid Number

Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.

January 1, 2026July 11, 2025
Count Unique Uncommon Words
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Count Unique Uncommon Words

Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.

January 1, 2026December 31, 2025
Find Missing AP Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Missing AP Sequence

Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.

December 31, 2025December 31, 2025
Extract Zip and Country Info
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Extract Zip and Country Info

Challenge No. 608: Extract zip code (5 or 6 digits in length) and country names.
Solved using: Python.

December 31, 2025July 11, 2025

Posts pagination

Previous 1 … 8 9 10 … 117 Next
  • 96 Common Challenges in Power Query
  • Advanced Mathematics Problem
  • Aggregation & Summarization
  • Books
  • Column Splitting
  • Column Transformation
  • Crispo Challenges
  • Custom Aggregation & Summarization
  • Custom Grouping
  • Data Cleaning
  • Data Transformation
  • data validation
  • Date & Time Handling
  • Excel Challenges
  • ExcelBI Excel Challenges
  • ExcelBI Power Query Challenges
  • Financial Problems
  • Indexing & Ranking
  • Merging & Joining
  • Missing Values
  • Omid Challenges
  • Pivot & Unpivot
  • Power Query Challenges
  • Python Challenges
  • Text Processing
  • ⭐️ Beginner
  • ⭐️⭐️ Easy
  • ⭐️⭐️⭐️ Intermediate
  • ⭐️⭐️⭐️⭐️ Advanced
  • ⭐️⭐️⭐️⭐️⭐️Expert
  • ⭐️⭐️⭐️⭐️⭐️⭐️Complex

BYROW CHAR CODE CONCAT DROP FILTER HSTACK IF IFERROR INDEX LAMBDA LEFT LEN LET List.Distinct List.Transform LOOKUP MAP MATCH MAX MID MONTH Python Python Automation Python for Data Analysis Python for Excel REDUCE ROW ROWS SCAN SEQUENCE SORT SUBSTITUTE Table.AddColumn Table.Group Table.SelectRows TAKE Text.Combine Text.Split TEXTJOIN TEXTSPLIT TOCOL UNIQUE VSTACK XLOOKUP

Recent Posts

  • Max Total on Consecutive Days
  • Extract Valid Year Ranges
  • Swap Grid Diagonals
  • Pivot with Total Line
  • Remove One Letter Palindrome

Recent Comments

No comments to show.
Copyright © 2026 OmidBI.
Powered by WordPress and HybridMag.
  • By Difficulty
    • ⭐️ Beginner
    • ⭐️⭐️ Easy
    • ⭐️⭐️⭐️ Intermediate
    • ⭐️⭐️⭐️⭐️ Advanced
    • ⭐️⭐️⭐️⭐️⭐️Expert
    • ⭐️⭐️⭐️⭐️⭐️⭐️Complex
  • By Topic
    • Advanced Mathematics Problem
    • Aggregation & Summarization
    • Column Splitting
    • Column Transformation
    • Custom Grouping
    • Data Cleaning
    • Data Transformation
    • Date & Time Handling
    • Financial Problems
    • Indexing & Ranking
    • Merging & Joining
    • Missing Values
    • Pivot & Unpivot
    • Text Processing
  • By Creator
    • Omid Challenges
    • ExcelBI Excel Challenges
    • ExcelBI Power Query Challenges
    • Crispo Challenges
  • By Software
    • DAX Challenges
    • Excel Challenges
    • Excel VBA Challenges
    • Google Sheets Challenges
    • Office Script Challenges
    • Power Query Challenges
    • Python Challenges
    • R Challenges
    • SQL Challenges
  • Books
    • 96 Common Challenges in Power Query