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
Custom Sequence from Four Terms
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Custom Sequence from Four Terms

Challenge No. 693: Generate a sequence taking first 4 numbers as 1, 2, 3, 4.
Solved using: Python.

February 11, 2026July 21, 2025
Team with All Wins
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Team with All Wins

Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.

February 11, 2026July 21, 2025
Assign Rank1 and Rank2
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Assign Rank1 and Rank2

Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.

February 10, 2026July 21, 2025
Sum of Values for Alphabets
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sum of Values for Alphabets

Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.

February 10, 2026July 21, 2025
Sequential Counter For IDs
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Sequential Counter For IDs

Challenge No. 689: This challenge is contributed by Duy Tùng
The task is to assign sequential numbers to the Result column based on the Number column.
Solved using: Python.

February 9, 2026
Sum Without First And Last
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sum Without First And Last

Challenge No. 688: Sum all the numbers given in column A except the first and last numbers in every cell.
Solved using: R.

February 9, 2026July 21, 2025
Fill Cell With Max Right-Down
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Fill Cell With Max Right-Down

Challenge No. 687: Fill in the blank with max of (max of remaining cells of row going to right and max of remaining cells of column going down).
Solved using: Python in Excel.

February 8, 2026July 21, 2025
Align Custom Data Layout
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Align Custom Data Layout

Challenge No. 686: This problem is contributed by RIJESH THOMAS
Align the data as shown.
Solved using: Python in Excel.

February 8, 2026July 21, 2025
Detect Overlapping Tasks
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Detect Overlapping Tasks

Challenge No. 685: List the tasks which are overlapping.
Solved using: Python in Excel.

February 7, 2026July 21, 2025
Align Names With Amounts
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Align Names With Amounts

Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.

February 7, 2026July 21, 2025

Posts pagination

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