Challenge No. 243: Transform the problem table into result table as shown.
Solved using: Python.
LAMBDA
Creates custom reusable functions in Excel.
Fill 5×5 Grid with Index
Challenge No. 536: Put values in a 5×5 grid as per their rows and columns positions.
Solved using: R.
Draw Grid by Rows/Columns
Challenge No. 535: This problem was contributed by Mehmet Çiçek.
Solved using: Python in Excel.
Reformat Item Entries
Challenge No. 242: 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.
Spread Yearly Rows to Columns
Challenge No. 240: Transpose the problem table into result table as shown.
Solved using: R.
Sum-Based Neighboring Grid Fill
Challenge No. 532: Apologies!! Scheduling didn’t work today.
Solved using: Python in Excel.
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.