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 14

⭐️⭐️ Easy

Slightly challenging problems for learners.

Encrypt Words with Tri Numeral Cipher
Posted in
  • Custom Grouping
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Encrypt Words with Tri Numeral Cipher

Challenge No. 397: Tri Numeral Alphabet Cipher – English alphabets are divided into groups containing 3 alphabets each and last group contain only 2 alphabets i.
Solved using: Python in Excel.

September 16, 2025July 23, 2025
Count Inversions in Number Sequence
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Count Inversions in Number Sequence

Challenge No. 396: Let’s say i and j are positions and e(i) and e(j) are elements from the string at that position.
Solved using: Python.

September 16, 2025July 23, 2025
Distance Matrix Between Cities
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Distance Matrix Between Cities

Challenge No. 160: x, y coordinates are given for different cities.
Solved using: Python in Excel.

September 16, 2025July 14, 2025
Encrypt with Autokey Cipher
Posted in
  • ExcelBI Excel Challenges
  • Text Processing
  • ⭐️⭐️ Easy

Encrypt with Autokey Cipher

Challenge No. 393: AUTOKEY CIPHER – Key is written beneath Plaintext and if key is shorter than Plaintext, then remaining slots beneath Plaintext are filled by letters from Plaintext starting from beginning.
Solved using: R.

September 14, 2025July 23, 2025
Reorder Letters by Position Type
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Reorder Letters by Position Type

Challenge No. 392: Reading from backwards, collect all letters occurring at even positions followed by all letters occurring at odd positions.
Solved using: Python in Excel.

September 14, 2025July 23, 2025
Assign Teachers to Students
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Assign Teachers to Students

Challenge No. 156: Last Sunday’s challenge was deemed to be super-difficult.
Solved using: Python.

September 12, 2025July 14, 2025
Extract Numbers Inside Parentheses
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Extract Numbers Inside Parentheses

Challenge No. 386: Extract the numbers from the string if ONLY numbers are contained within the parentheses.
Solved using: Python in Excel.

September 11, 2025July 22, 2025
Render Provided Grid Design
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Render Provided Grid Design

Challenge No. 385: Generate the given grid.
Solved using: R.

September 10, 2025July 22, 2025
Generate Kamasutra Cipher Encryption
Posted in
  • ExcelBI Excel Challenges
  • Text Processing
  • ⭐️⭐️ Easy

Generate Kamasutra Cipher Encryption

Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.

September 9, 2025July 22, 2025
Split on First Greater Sum
Posted in
  • Column Splitting
  • ExcelBI Excel Challenges
  • ⭐️⭐️ Easy

Split on First Greater Sum

Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.

September 7, 2025July 22, 2025

Posts pagination

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