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
Find Watson-Crick Palindromes
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Find Watson-Crick Palindromes

Challenge No. 551: Watson-Crick (WK) Palindromes – A DNA string is a Watson-Crick (WK) Palindrome when the complement of its reverse is equal to itself.
Solved using: Python in Excel.

December 2, 2025July 30, 2025
Calculate Finish Stock and Starting
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Calculate Finish Stock and Starting

Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.

December 2, 2025July 14, 2025
Odd Numbers All Directions
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Odd Numbers All Directions

Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.

December 2, 2025July 30, 2025
Transpose problem table into result
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Transpose problem table into result

Challenge No. 249: Transpose problem table into result table.
Solved using: Python.

December 1, 2025July 14, 2025
Tap Code Cipher Generator
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Tap Code Cipher Generator

Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.

December 1, 2025July 30, 2025
Triangular Pair Sums and Differences
Posted in
  • ExcelBI Excel Challenges
  • ⭐️⭐️⭐️ Intermediate

Triangular Pair Sums and Differences

Challenge No. 547: We had some challenges on Triangular numbers.
Solved using: Python.

November 30, 2025July 30, 2025
Transpose the problem table into
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️⭐️ Easy

Transpose the problem table into

Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.

November 30, 2025July 14, 2025
Odd Numbers in Matrix
Posted in
  • ExcelBI Excel Challenges
  • ⭐️ Beginner

Odd Numbers in Matrix

Challenge No. 546: List the odd numbers reading rows from left to right and columns from top to bottom.
Solved using: Python.

November 30, 2025July 30, 2025
Rank Players by Uppercase
Posted in
  • ExcelBI Excel Challenges
  • Indexing & Ranking
  • ⭐️ Beginner

Rank Players by Uppercase

Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.

November 29, 2025July 30, 2025
Prepare the result table on
Posted in
  • ExcelBI Power Query Challenges
  • ⭐️ Beginner

Prepare the result table on

Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.

November 29, 2025July 14, 2025

Posts pagination

Previous 1 … 16 17 18 … 117 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