Challenge No. 358: Stack both the diagonals of n x n metrices horizontally.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Build Dictionary Excluding Vowels
Challenge No. 357: Prepare dictionary entries from Key Value pairs.
Solved using: Python in Excel.
Exclude Weekend Vacation Dates
Challenge No. 139: Prepare the Result table.
Solved using: DAX.
Digits with Higher Frequency
Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.
Validate IPv6 Address Format
Challenge No. 355: List all valid IPv6 addresses.
Solved using: Python in Excel.
Find Missing Letters in Range
Challenge No. 353: Find the missing letters.
Solved using: R.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
List Interprime Numbers
Challenge No. 352: List the Interprime Numbers.
Solved using: Python in Excel.
Reverse Words Between Indexes
Challenge No. 351: Reverse the words between two words whose both inclusive positions are given.
Solved using: Python in Excel.
Detect Common Groups by ID
Challenge No. 136: Find the common groups on the basis of common IDs.
Solved using: R.
