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 2

⭐️⭐️ Easy

Slightly challenging problems for learners.

Distribute Consecutive Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Distribute Consecutive Numbers

Challenge No. 674: This challenge has been contributed by Mehmet Çiçek
List consecutive numbers into different columns.
Solved using: Python in Excel.

February 2, 2026July 21, 2025
Word Pairs With All Vowels
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Word Pairs With All Vowels

Challenge No. 671: Find the pair of words which together contain all 5 vowels.
Solved using: Python in Excel.

January 31, 2026July 21, 2025
First Ten Tech Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

First Ten Tech Numbers

Challenge No. 669: Tech Number – A number is a tech number if it has even number of digits and square of sum of first half and last half is equal to number itself.
Solved using: R.

January 30, 2026
Cube With Equal Digits
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Cube With Equal Digits

Challenge No. 659: Find those 2 digits to 5 digits numbers whose cube results into numbers where frequency of appearing digits are same.
Solved using: Python.

January 25, 2026July 21, 2025
Check Valid Word Square
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Check Valid Word Square

Challenge No. 658: Word Square – A word square is a n x n matrix where row (i) = column (i).
Solved using: Python.

January 25, 2026July 21, 2025
Running Total With Reset
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Running Total With Reset

Challenge No. 649: Calculate the running total for each group.
Solved using: Python.

January 20, 2026July 21, 2025
Pattern Recognition Generator
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Pattern Recognition Generator

Challenge No. 647: Understand the pattern and generate it.
Solved using: Python.

January 19, 2026July 21, 2025
List Alphabet And Numbers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

List Alphabet And Numbers

Challenge No. 642: List all consecutive alphabets in Data column separated by comma.
Solved using: Excel VBA.

January 17, 2026July 21, 2025
Wrap Rows By Number Gaps
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Wrap Rows By Number Gaps

Challenge No. 641: Extend the given numbers into row and wrap the row where absolute gap between two subsequent numbers is greater than 2.
Solved using: R.

January 16, 2026
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

Posts pagination

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