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

Grid Lookup By Pattern

Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.

February 6, 2026July 21, 2025
Split And Sum Orders
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Split And Sum Orders

Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.

February 6, 2026July 21, 2025
Split And Align Columns
Posted in
  • Column Splitting
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Split And Align Columns

Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.

February 5, 2026July 21, 2025
Last Selected Queue Item
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Last Selected Queue Item

Challenge No. 679: For production runs, number of items (say N) to be selected in one go is given in every column.
Solved using: Python.

February 4, 2026July 21, 2025
Even-Odd Reversed Squares
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Even-Odd Reversed Squares

Challenge No. 678: Find first 50 numbers (at least 2 digits) where
1.
Solved using: Python.

February 4, 2026July 21, 2025
Quarterly Payment Grouping
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Quarterly Payment Grouping

Challenge No. 676: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Divide the payments among different quarters / months.
Solved using: R.

February 3, 2026July 21, 2025
Signed Permutation Generator
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Signed Permutation Generator

Challenge No. 675: This problem is contributed by Sunny Baggu
Given 2 input numbers, create all possible permutations considering numbers as both positive and negative.
Solved using: Python.

February 2, 2026
Distribute Consecutive Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Distribute Consecutive Numbers

Challenge No. 674: This challenge has been contributed by Mehmet Çiçek
List consecutive numbers into different columns.
Solved using: Python in Excel.

February 2, 2026July 21, 2025
Draw Star Shape Pattern
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Draw Star Shape Pattern

Challenge No. 673: Create the star patterns for given N.
Solved using: R.

February 1, 2026July 21, 2025
Calculate Level Hierarchy Totals
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Calculate Level Hierarchy Totals

Challenge No. 672: Level 1 is sum of Level 2.
Solved using: R.

February 1, 2026July 21, 2025

Posts pagination

Previous 1 2 3 4 … 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