Challenge No. 529: Extract the numbers and sum them along with their signs.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Fill Blanks with Column Index
Challenge No. 237: Fill in the blanks / nulls with column name_1, 2, 3.
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.
Exclude Weekend Leave Days
Challenge No. 234: Find the total leaves taken by the employees.
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.
Build Alphabet Staircase
Challenge No. 523: Make the staircase of alphabets.
Solved using: Excel VBA.