Challenge No. 237: Fill in the blanks / nulls with column name_1, 2, 3.
Solved using: Python.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
Validate Chessboard Pattern
Challenge No. 525: Determine whether a given chess board is valid or not.
Solved using: Python.
Complete Square by X Placeholder
Challenge No. 524: Fill in the digit marked as X to make the number a perfect square.
Solved using: R.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
Solved using: Python.
Build Alphabet Staircase
Challenge No. 523: Make the staircase of alphabets.
Solved using: Excel VBA.
Sum of Odd Numbers Sequence
Challenge No. 522: Check if a number can be expressed as a sum of consecutive odd numbers.
Solved using: Python in Excel.