Challenge No. 139: Prepare the Result table.
Solved using: DAX.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Digits with Higher Frequency
Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.
Transpose People Table
Challenge No. 138: Transpose the problem table into result table.
Solved using: R.
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.
Find Insolite Numbers
Challenge No. 350: List the Insolite Numbers – A number is Insolite if it is divisible by both
Sum of square of its digits AND
Product of square of its digits
Ex.
Solved using: Python in Excel.
Assign Groups to Value Bins
Challenge No. 135: Generate the result table which is as per bin size.
Solved using: R.