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 » ⭐️ Beginner » Page 14

⭐️ Beginner

Easy challenges for newcomers.

Parasitic Number Identification
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Parasitic Number Identification

Challenge No. 452: Parasitic number – is a positive natural number which, when multiplied by single digit n, results in movement of the last digit to its front.
Solved using: Excel VBA.

October 14, 2025July 23, 2025
Max Consecutive Number Streak
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Max Consecutive Number Streak

Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.

October 13, 2025July 23, 2025
Rank Sales with Tie Handling
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Rank Sales with Tie Handling

Challenge No. 450: Assign rank on the basis of sales made by different salespersons in a company.
Solved using: Excel VBA.

October 13, 2025July 23, 2025
Group and Sum
Posted in
  • Aggregation & Summarization
  • Crispo Challenges
  • Custom Grouping
  • ⭐️ Beginner

Group and Sum

Challenge No. 59: Group and Sum Shop Fruit Sales
e.
Solved using: R.

October 12, 2025July 11, 2025
Find Penholodigital Squares
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Penholodigital Squares

Challenge No. 447: Penholodigital squares are perfect square numbers that contain digits from 1 to 9 exactly once.
Solved using: R.

October 11, 2025July 23, 2025
Delete Duplicate Rows
Posted in
  • Crispo Challenges
  • ⭐️ Beginner

Delete Duplicate Rows

Challenge No. 58: Delete rows with duplicate Invoice, User & Dept, whose values can be completely Offset.
Solved using: Python.

October 9, 2025July 11, 2025
Find Birds in Grid Rows
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Find Birds in Grid Rows

Challenge No. 443: Given 10×10 grid in A2:K11 contains bird names across rows (not in columns).
Solved using: Python in Excel.

October 9, 2025July 23, 2025
Generate Integers From Ranges
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Generate Integers From Ranges

Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.

October 8, 2025July 23, 2025
Generate Excel Column Headers
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Generate Excel Column Headers

Challenge No. 434: Generate the columns headers of Excel in a 20×5 matrix as shown.
Solved using: Python.

October 5, 2025July 23, 2025
Split Delimited Text into Columns
Posted in
  • Column Splitting
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Split Delimited Text into Columns

Challenge No. 433: Split the given text into columns.
Solved using: R.

October 4, 2025July 23, 2025

Posts pagination

Previous 1 … 13 14 15 … 41 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