Challenge No. 536: Put values in a 5×5 grid as per their rows and columns positions.
Solved using: R.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Unstack Columns to Rows
Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.
Next Palindrome with Repeats
Challenge No. 534: Find the next 3 Palindrome numbers for the given numbers where any digit is repeated by the numbers given in Repeats column.
Solved using: Python in Excel.
Reformat Item Entries
Challenge No. 242: Transform the problem table into result table as shown.
Solved using: Python.
Draw Symmetric Star in ASCII
Challenge No. 533: Draw ASCII star for given N which is an odd number for the purpose of symmetry.
Solved using: Python in Excel.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Remove Digit to Make Divisible
Challenge No. 531: List first 500 numbers starting with 101 which don’t end with 0 and are divisible at least once by removing one digit at a time from the number.
Solved using: R.
Max Sale Date and Amount
Challenge No. 530: Find the dates when maximum sales was made for a person and also list the corresponding amount.
Solved using: Python.
Rank Sales Drop Per Person
Challenge No. 239: Transpose the problem table into result table and calculate the drop in sales amount from one quarter to previous quarter.
Solved using: Python.
Signed Number String Sum
Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.