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
Populate the addresses for Greek
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Populate the addresses for Greek

Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.

December 14, 2025July 14, 2025
Sort Odd Position Values
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Sort Odd Position Values

Challenge No. 574: Keep the numbers in even positions as it is and sort the numbers in odd positions.
Solved using: R.

December 14, 2025July 30, 2025
Calculate Name-Based Durations
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Calculate Name-Based Durations

Challenge No. 573: Work out the durations in hours against all names.
Solved using: Python.

December 13, 2025July 30, 2025
Rank stores by percentage of
Posted in
  • ExcelBI Power Query Challenges
  • Indexing & Ranking
  • ⭐️⭐️⭐️ Intermediate

Rank stores by percentage of

Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.

December 13, 2025July 14, 2025
Weekly Count by Category
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Weekly Count by Category

Challenge No. 572: Week 1 starts from 1st of the month.
Solved using: Python in Excel.

December 13, 2025July 30, 2025
Digit-Constrained Product Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Digit-Constrained Product Numbers

Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.

December 12, 2025July 30, 2025
Swap Letters by Index Pair
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Swap Letters by Index Pair

Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.

December 12, 2025July 30, 2025
Absolute Alphabet Frequency Difference
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Absolute Alphabet Frequency Difference

Challenge No. 569: Find the count of alphabets in String1 and String2 and take the absolute difference of count of common alphabets and retain the non-common ones, combine those alphabets along with their counts (sorted alphabetically).
Solved using: Python in Excel.

December 11, 2025July 30, 2025
Transpose the given data from
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️ Intermediate

Transpose the given data from

Challenge No. 261: Transpose the given data from Problem Table into Result table as shown.
Solved using: Python in Excel.

December 11, 2025July 14, 2025
Expand Alphabet Letter Gaps
Posted in
  • ExcelBI Excel Challenges
  • Missing Values
  • ⭐️⭐️⭐️ Intermediate

Expand Alphabet Letter Gaps

Challenge No. 568: Fill in the missing letters between two letters in the given words.
Solved using: Python.

December 11, 2025July 30, 2025

Posts pagination

Previous 1 … 13 14 15 … 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