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 10

⭐️⭐️ Easy

Slightly challenging problems for learners.

Next Larger Permutation
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Next Larger Permutation

Challenge No. 470: Find the next number which is greater and made from arranging digits from that number.
Solved using: Python in Excel.

October 23, 2025July 23, 2025
List Palindromic Evil Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

List Palindromic Evil Numbers

Challenge No. 464: Work out the first 1000 Evil Numbers (at least 2 digits) which are Palindromic also.
Solved using: Python in Excel.

October 20, 2025July 23, 2025
Merge Subject Maximum Marks
Posted in
  • ExcelBI Power Query Challenges
  • Merging & Joining
  • ⭐️⭐️ Easy

Merge Subject Maximum Marks

Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.

October 19, 2025July 14, 2025
Identify Anti-Perfect Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Identify Anti-Perfect Numbers

Challenge No. 455: Anti perfect number is that number where number is equal to sum of reverse of its perfect divisors’ digits.
Solved using: Python in Excel.

October 15, 2025July 23, 2025
Reverse Cumulative Row Sums
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Reverse Cumulative Row Sums

Challenge No. 194: The cumulative sum across rows is given in problem table.
Solved using: Python in Excel.

October 13, 2025July 14, 2025
Identify Rotated String Matches
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Identify Rotated String Matches

Challenge No. 449: List the String1 and String2 if they are rotated versions of each other.
Solved using: Python in Excel.

October 12, 2025July 23, 2025
Generate Triangles By Row Count
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Generate Triangles By Row Count

Challenge No. 448: Given the r (number of rows) value in column A, generate the given triangles.
Solved using: Python.

October 12, 2025July 23, 2025
Unstack Groups for Summation
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Unstack Groups for Summation

Challenge No. 193: Transpose the problem table into result table.
Solved using: Python in Excel.

October 12, 2025July 14, 2025
Top 3 Closest City Pairs
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️⭐️ Easy

Top 3 Closest City Pairs

Challenge No. 446: The distance between two cities is given in the grid.
Solved using: R.

October 11, 2025July 23, 2025
Generate Look-and-Say Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Generate Look-and-Say Sequence

Challenge No. 444: Look & Say Sequence
Going from Left to Right in a number, take a digit and insert how many times this digit appears to the left of the digit.
Solved using: Python in Excel.

October 10, 2025July 23, 2025

Posts pagination

Previous 1 … 9 10 11 … 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