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 Word by Exact Index
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Find Word by Exact Index

Challenge No. 367: Capture the word starting at given index.
Solved using: Python.

September 1, 2025July 21, 2025
12-Month Cumulative Sales
Posted in
  • Date & Time Handling
  • ExcelBI Power Query Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

12-Month Cumulative Sales

Challenge No. 145: For every store, find the cumulative sale for 12 months periods.
Solved using: R.

September 1, 2025July 14, 2025
Alternate Letters and Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Alternate Letters and Numbers

Challenge No. 366: Arrange the given characters in such a fashion that alphabets occupy all odd positions and numbers occupy even position in the order in which they appear.
Solved using: Python.

September 1, 2025July 21, 2025
One Digit Equals Other Sum
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

One Digit Equals Other Sum

Challenge No. 365: List the numbers where one digit is equal to sum of other digits.
Solved using: R.

August 31, 2025July 21, 2025
Split Group and Track Running
Posted in
  • Custom Grouping
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Split Group and Track Running

Challenge No. 144: Divide the data set for a group in 2 halves.
Solved using: Python in Excel.

August 31, 2025July 14, 2025
Sequential Digit Difference Match
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Sequential Digit Difference Match

Challenge No. 364: List the numbers where absolute difference between two succeeding digits is 1, 2, 3, 4.
Solved using: Python.

August 31, 2025July 21, 2025
Increment Number at Word End
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Increment Number at Word End

Challenge No. 363: If any word contains numbers at the end of the word, add 1 to that number.
Solved using: Python in Excel.

August 30, 2025July 21, 2025
First and Last Duplicates
Posted in
  • ExcelBI Power Query Challenges
  • Indexing & Ranking
  • ⭐️⭐️⭐️⭐️⭐️Expert

First and Last Duplicates

Challenge No. 143: List those rows for employees where first and last duplicate values occur for a value.
Solved using: Python in Excel.

August 30, 2025July 14, 2025
Uppercase Letters Around Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Uppercase Letters Around Numbers

Challenge No. 362: Convert the English letters around a number to upper case.
Solved using: Python in Excel.

August 30, 2025July 21, 2025
Extract Longest Alphanumeric Segment
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Extract Longest Alphanumeric Segment

Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.

August 29, 2025July 21, 2025

Posts pagination

Previous 1 … 44 45 46 … 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