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
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sum of Numbers following Hashes

Challenge No. 591: .
Solved using: Python.

December 22, 2025July 11, 2025
List Consecutive Streak Indexes
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️⭐️⭐️ Intermediate

List Consecutive Streak Indexes

Challenge No. 590: If there are more than one consecutive streaks of H or T, then list the Indexes of those.
Solved using: Python in Excel.

December 22, 2025July 11, 2025
Missing Letters and Frequencies
Posted in
  • ExcelBI Excel Challenges
  • Missing Values
  • ⭐️ Beginner

Missing Letters and Frequencies

Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.

December 21, 2025July 11, 2025
Pick top N by group
Posted in
  • Custom Grouping
  • ExcelBI Power Query Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Pick top N by group

Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.

December 21, 2025July 14, 2025
Minimum Sum Unique Pairs
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Minimum Sum Unique Pairs

Challenge No. 588: Find the unique pairs for which sum in minimum across the columns.
Solved using: R.

December 21, 2025July 11, 2025
Repeat Vowels by Position
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Repeat Vowels by Position

Challenge No. 587: Repeat the vowels as per their order of occurrence.
Solved using: Python in Excel.

December 20, 2025July 11, 2025
Animal Park Presence Matrix
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Animal Park Presence Matrix

Challenge No. 586: List all animals and all parks.
Solved using: Python.

December 20, 2025July 11, 2025
Cross Product with Repeats
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Cross Product with Repeats

Challenge No. 585: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: Python.

December 19, 2025July 11, 2025
Find all possible routes from
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Find all possible routes from

Challenge No. 269: Find all possible routes from City1 to various other cities.
Solved using: Python.

December 19, 2025July 14, 2025
Cross Product with Multiples
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Cross Product with Multiples

Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.

December 19, 2025July 11, 2025

Posts pagination

Previous 1 … 11 12 13 … 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