Challenge No. 245: List all Diamond strings from column A.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Find Super Palindromes
Challenge No. 244: List all Super-palindromes from column A.
Solved using: Python in Excel.
Decrypt Polybius Cipher Grid
Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
Eight Queens Puzzle!
Challenge No. 150: Theeight-queenss puzzle is the problem of placing eight chess queens on an 8×8 chessboard so that no two queens threaten each other; thus, a solution requires that no two queens share the same row, column, or diagonal.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Combine, List.Transform), and Python in Excel.
Prime Difference Category
Challenge No. 242: If Number1 and Number2 are primes and if difference between them is:
2 – Twin Prime
4 – Cousin Prime
6 – Sixy Prime
Categorize the Numbers given in column A and B.
Solved using: Power Query (List.Transform).
Alternate Letter Casing
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
Extract From Text! Part 3
Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Rotate Rows and Columns
Challenge No. 240: Now rotation has to be done for both columns and rows.
Solved using: Power Query.
Sum Values by Letter Codes
Challenge No. 77: Generate the result table from problem table.
Solved using: Python in Excel.
Sorted Vowel Substitution
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.