Challenge No. 286: List all Right Truncatable Primes.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Unique Dept-Name Combinations
Challenge No. 102: Prepare unique combinations of Dept and corresponding names.
Solved using: Power Query (List.Transform).
Generate Demlo Numbers diamond
Challenge No. 285: Generate Demlo Numbers diamond.
Solved using: R.
Table Transformation! Part 20
Challenge No. 171: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform), Python, Python in Excel, and R.
Unique Combinations Matching Sum
Challenge No. 284: Find out unique combination of numbers from column A containing N numbers given in column B which sums to column C.
Solved using: Python in Excel.
Code State-Branch Combinations
Challenge No. 101: Create codes for the combination of State and Branch.
Solved using: Power Query.
Group Words by Anagrams
Challenge No. 282: An anagram is a word which is made by arranging the letters of another word.
Solved using: Python in Excel.
Calculate Quarterly Working Payment
Challenge No. 100: Per day rates for every person for a duration is given.
Solved using: Python in Excel.
Find Divisible Substrings Sorted
Challenge No. 281: List all the substrings from Number1 which are divisible by Number2.
Solved using: Python in Excel.
Extract From Text! Part 7
Challenge No. 169: Similar to Challenge 149, extract the texts between the pairs of the characters listed below.
Solved using:Excel (ARRAYTOTEXT, LAMBDA, MAP), Google Sheets, Power Query (List.Split, List.Transform, Text.Combine), Python, Python in Excel, and R.