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.
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.
Signed Number String Sum
Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.
Fill Blanks with Column Index
Challenge No. 237: Fill in the blanks / nulls with column name_1, 2, 3.
Solved using: Python.
Draw Alphabetic Diamond
Challenge No. 528: Generate the diamond of alphabets as per the numbers given in column A.
Solved using: Python.
Split Periods For The Project
Challenge No. 74: Create Weekly Date Groups and Sum
A Week runs from Monday to Sunday
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Index-wise Base Encoding Sort
Challenge No. 527: Convert every digit from right to left in the base of its index + 1 reading index 1, 2.
Solved using: Python.
Align Nested Headers
Challenge No. 236: Transpose the data as shown.
Solved using: Python in Excel.
Next Three Palindromes
Challenge No. 526: A palindrome number is that which is same even when read backwards.
Solved using: Python in Excel.
Validate Chessboard Pattern
Challenge No. 525: Determine whether a given chess board is valid or not.
Solved using: Python.