Challenge No. 421: Stack the diagonals read from left to right of a matrix in rows.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Split by Alpha-Numeric Change
Challenge No. 417: Split the given strings whenever a changeover happens between English alphabets and numbers.
Solved using: Excel VBA.
Generate Number Outline Sequence
Challenge No. 416: Generate the number outlining.
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.
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.
Clockwise Angle Between Clock Hands
Challenge No. 408: Find the angle from hour hand to minute hand in a clock in clock-wise direction.
Solved using: DAX.
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.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.