Challenge No. 139: Prepare the Result table.
Solved using: DAX.
By Topic
Challenges categorized by topic.
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.
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 Longest Consecutive Sequence
Challenge No. 347: List the largest group of consecutive numbers in each column.
Solved using: R.
Meter Reading Consumption Split
Challenge No. 133: Find out the electricity consumption for all 3 meters for given dates.
Solved using: R.
List valid South African National IDs
Challenge No. 342: List the valid South African National IDs (person identification numbers).
Solved using: Python in Excel.
Unpivot and Merge Names
Challenge No. 132: Unpivot the problem table into result table.
Solved using: Python in Excel.
People Connection!
Challenge No. 200: In the question table, direct connections between people are provided.
Solved using:Excel (IF, IFNA, INDEX), Power Query (List.Transform, Text.End), Python, Python in Excel, and R.