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
Find Longest Consecutive Sequence
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Find Longest Consecutive Sequence

Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.

August 22, 2025July 21, 2025
Daily Stock Closing Value
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Daily Stock Closing Value

Challenge No. 134: Yesterday’s challenge was a tough one.
Solved using: Python in Excel.

August 22, 2025July 14, 2025
Replace letters with nearest vowels
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Replace letters with nearest vowels

Challenge No. 346: The string contains only English alphabets.
Solved using: Python in Excel.

August 22, 2025July 21, 2025
Sum digits along diagonals of grid
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sum digits along diagonals of grid

Challenge No. 345: Find the sum of digits of both the diagonals for the grids given.
Solved using: R.

August 21, 2025July 21, 2025
Meter Reading Consumption Split
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️⭐️⭐️Complex

Meter Reading Consumption Split

Challenge No. 133: Find out the electricity consumption for all 3 meters for given dates.
Solved using: R.

August 21, 2025July 14, 2025
List all Katadrome numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

List all Katadrome numbers

Challenge No. 344: List all Katadrome numbers.
Solved using: Python in Excel.

August 21, 2025July 21, 2025
Find nearest Palindrome numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Find nearest Palindrome numbers

Challenge No. 343: Palindrome number is that which is same even when read backwards.
Solved using: R.

August 20, 2025July 21, 2025
Unpivot and Merge Names
Posted in
  • ExcelBI Power Query Challenges
  • Pivot & Unpivot
  • ⭐️⭐️⭐️⭐️⭐️Expert

Unpivot and Merge Names

Challenge No. 132: Unpivot the problem table into result table.
Solved using: Python in Excel.

August 20, 2025July 14, 2025
List valid South African National IDs
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

List valid South African National IDs

Challenge No. 342: List the valid South African National IDs (person identification numbers).
Solved using: Python in Excel.

August 20, 2025July 21, 2025
Sort odd positioned numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sort odd positioned numbers

Challenge No. 341: Sort the numbers at odd positions.
Solved using: Python in Excel.

August 19, 2025July 21, 2025

Posts pagination

Previous 1 … 47 48 49 … 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