Challenge No. 172: Find the missing English Alphabets from First Ladies column.
Solved using: Power Query.
⭐️ Beginner
Easy challenges for newcomers.
Substring Repeat Detection
Challenge No. 171: A string can be made by repetitions of substrings.
Solved using: Excel VBA.
Sort Cities by Populated
Challenge No. 169: Order the cities columns on the basis of number of cells populated in descending order.
Solved using: Python.
Uppercase Position Finder
Challenge No. 168: Find the positions of uppercase letters and separate them by dashes.
Solved using: Excel VBA.
Find Missing Tuple Number
Challenge No. 167: Pythagorean tuples are those numbers which follow the rule a^2+b^2=c^2 where a, b and c are whole numbers.
Solved using: Python in Excel.
Porta Cipher Grid Formula
Challenge No. 166: The grid shown is used in Porta Cipher for Cryptography.
Solved using: Python in Excel.
Data Grouping
Challenge No. 43: Group the staff into their respective salary ranges
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Symbol Replace by Frequency
Challenge No. 163: If an alphabet appears once in a word, replace it with a “?”.
Solved using: Power Query (Table.AddColumn).
Vernam Cipher Encrypt
Challenge No. 162: Vernam Cipher (also known as One time pad cipher)
1.
Solved using: Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip).
Counting TextString
Challenge No. 42: Count Stalls Stocking either Apple or Kiwi
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.