Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Incremental Caesar Cipher
Challenge No. 236: We had 3 challenges on Caesar’s Cipher (if you are unaware about Caesar’s Cipher, I will encourage you to visit previous challenge to get an idea)
This is a variation of Caesar’s Cipher.
Solved using: Power Query (List.Transform).
Group Text by Keyword
Challenge No. 235: Populate the Groups (from table 2) on the basis of words appearing in Text column.
Solved using: Power Query.
Check Pandigital by Base
Challenge No. 231: List Yes if a Number is Pandigital number in a given base else No.
Solved using: Power Query.
Create Snake Number Grid
Challenge No. 230: This challenge is contributed by Mehmet Çiçek.
Solved using: Excel VBA.
Encrypt Using Affine Cipher
Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.
Classify Deficient Perfect Abundant
Challenge No. 228: Take a positive integer n and add its positive divisors (let’s denote it by S)
Classify the numbers as per given criteria:
If S < 2n = Deficient Number
If S = 2n = Perfect Number
If S > 2n = Abundant Number
Ex.
Solved using: Python in Excel.
Find Kangaroo and Joey Words
Challenge No. 225: Kangaroo words are those words which contain the other words within themselves.
Solved using: Excel VBA.
Sort Rows by Key Count
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
List Left Truncatable Primes
Challenge No. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.