Challenge No. 338: Calculate check digit using Damm algorithm.
Solved using: Python in Excel.
MID
Extracts a substring from a text string at a given position in Excel.
Count of numbers where digits’ product equals value
Challenge No. 337: Find the Min, Max and Count of numbers having number of digits in column A whose product of digits is equal to column B.
Solved using: R.
Decrypt using 5×76 transposition cipher
Challenge No. 335: This is a 5 x 76 transposition cipher, where you start with the letter in the final position (‘W’) and then repeatedly step back through the whole ciphertext 5 positions at a time time, and then repeat that same process but starting from the letter one before the last position (‘T’) etc, revealing the first words of Geoffrey Chaucer’s ‘Canterbury Tales’.
Solved using: Python in Excel.
Generate Soundex Codes
Challenge No. 128: Every Soundex code consists of a letter and three numbers, such as W-252.
Solved using: R.
Extract string before any letter repeats
Challenge No. 333: Extract the string before any alphabet is repeated.
Solved using: R.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
Missing Characters!
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Find the first 50 Iccanobif numbers
Challenge No. 329: Find the first 50 Iccanobif numbers.
Solved using: Python.
Text Split
Challenge No. 57: Split the group of texts into single characters
Dynamic array function allowed, but extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Find palindromic substrings with at least 3 digits
Challenge No. 323: Find the substrings of given numbers which are Palindromic.
Solved using: DAX.