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
Home » Challenges » By Difficulty » ⭐️⭐️ Easy » Page 3

⭐️⭐️ Easy

Slightly challenging problems for learners.

Toggle Arithmetic Operation Signs
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Toggle Arithmetic Operation Signs

Challenge No. 629: If a number is preceded by + or -, change + to – and – to +.
Solved using: Python.

January 10, 2026July 11, 2025
Calculate Cheapest Bottle Combination
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Calculate Cheapest Bottle Combination

Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.

January 10, 2026July 11, 2025
Find Divisor Square Sums
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Find Divisor Square Sums

Challenge No. 625: Find all the factors of a number, square these factors and sum which is called Divisor Square Sum.
Solved using: Excel VBA.

January 8, 2026July 11, 2025
Generate Sequential Ticket Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Generate Sequential Ticket Numbers

Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.

January 6, 2026July 11, 2025
Top 3 Salespersons per Quarter
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Top 3 Salespersons per Quarter

Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.

January 5, 2026July 11, 2025
Rank Cities by Percent Change
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Rank Cities by Percent Change

Challenge No. 615: List the top 3 cities where sum of %change from 2020 to 2021 and 2021 to 2022 is the highest.
Solved using: Python.

January 3, 2026July 11, 2025
Find Maximum N-Digit Grid Number
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Find Maximum N-Digit Grid Number

Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.

January 1, 2026July 11, 2025
Identify Missing Number Ranges
Posted in
  • ExcelBI Excel Challenges
  • Missing Values
  • ⭐️⭐️ Easy

Identify Missing Number Ranges

Challenge No. 603: Find the missing numbers in the grid given between the smallest and the largest numbers.
Solved using: Python.

December 28, 2025July 11, 2025
Transpose table, compute gross profit
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose table, compute gross profit

Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.

December 28, 2025July 14, 2025
Transpose the data as shown
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose the data as shown

Challenge No. 277: Transpose the data as shown.
Solved using: Python.

December 27, 2025July 14, 2025

Posts pagination

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