Challenge No. 410: List all decimal numbers whose Roman equivalents are Palindromic.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
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.
Stack and Transform Columns
Challenge No. 171: Transpose given problem table into result table.
Solved using: Python.
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.
Find Sides of Right Triangle
Challenge No. 406: For a right angled triangle, Area and Hypotenuse are given.
Solved using: Python in Excel.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
List Prime-Surrounded Sandwich Numbers
Challenge No. 405: Sandwich numbers – A number is said to be a Sandwich number if the number prior to it and the number after it, both are primes.
Solved using: Excel VBA.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.