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
Sum Between Plus Groups
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Sum Between Plus Groups

Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.

January 16, 2026July 21, 2025
Calculate Daily Work Hours
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Calculate Daily Work Hours

Challenge No. 639: Find the total time in hours worked on each day.
Solved using: Python in Excel.

January 15, 2026July 21, 2025
Generate Unique Day Abbreviations
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Generate Unique Day Abbreviations

Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.

January 15, 2026July 21, 2025
Insert Dashes for Nonconsecutives
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Insert Dashes for Nonconsecutives

Challenge No. 637: Given alphanumeric strings, insert a dash if two characters are not consecutive in increasing order.
Solved using: Python in Excel.

January 14, 2026July 21, 2025
Identify Yearly Repeat Customers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Identify Yearly Repeat Customers

Challenge No. 636: Find the unique repeat customers in a year.
Solved using: Python.

January 14, 2026July 21, 2025
Compare Unique Array Elements
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Compare Unique Array Elements

Challenge No. 634: Starting the week on a comfortable note.
Solved using: R.

January 13, 2026July 21, 2025
Encrypt Words with Random Characters
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️ Advanced

Encrypt Words with Random Characters

Challenge No. 633: Encrypt the given words with following rules
1.
Solved using: Python.

January 12, 2026July 21, 2025
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

No Challenge Provided

Challenge No. 632: .
Solved using: Python in Excel.

January 12, 2026July 11, 2025
Calculate Actual Task Durations
Posted in
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️⭐️⭐️Expert

Calculate Actual Task Durations

Challenge No. 631: This challenge has been contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python in Excel.

January 11, 2026July 11, 2025
Find Immediate Previous Caller
Posted in
  • Custom Grouping
  • Date & Time Handling
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Find Immediate Previous Caller

Challenge No. 630: For each date group, populate the immediate last caller.
Solved using: Python in Excel.

January 11, 2026July 11, 2025

Posts pagination

Previous 1 … 6 7 8 … 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