Challenge No. 175: List the Names along with the Names of next generation and relationship between generations.
Solved using: Python.
LAMBDA
Creates custom reusable functions in Excel.
Cyclops and Triangular Numbers
Challenge No. 415: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits and >=3 digits).
Solved using: Python in Excel.
Validate IMO Check Digit
Challenge No. 414: IMO Number of a Vessel – This is a 7 digit number where last digit is check digit.
Solved using: Python in Excel.
Monthly Sales Split Calendar Days
Challenge No. 174: For all employees, insert the rows for each month and divide the Sales amount over these months as per number of calendars days in the month.
Solved using: R.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Square Digits Until Single Number
Challenge No. 412: Square the individual digits of a number and sum them.
Solved using: Python in Excel.
Roman Palindromic Numbers
Challenge No. 410: List all decimal numbers whose Roman equivalents are Palindromic.
Solved using: Python.
Calculate Agent Commission Totals
Challenge No. 172: Find the total commission paid to each agent along with a Grand Total row.
Solved using: R.
Normalize Table from Merged Cells
Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.
Reverse, Cipher and Shift Text
Challenge No. 407: Mirror Cipher with Caesar’s Shift – Reverse the words and then reverse the alphabets within the words.
Solved using: Python.