Challenge No. 162: Extract alphabet and two digit numbers strings if alphabet and two digit numbers are separated by a special character.
Solved using: R.
Check Connectivity of Random Points
Challenge No. 400: Coordinates for points are given in x, y format.
Solved using: R.
Count Unique Letters in String
Challenge No. 399: Extract the unique alphabets from the given strings and count their frequencies of occurrence.
Solved using: Python.
Winning Numbers Weekly Range
Challenge No. 161: For each group, find the maximum occurring Winning numbers within a period of 7 weeks .
Solved using: Python in Excel.
Min and Max Dates by Group
Challenge No. 398: Generate the min and max dates for different year and month combinations.
Solved using: Python in Excel.
Encrypt Words with Tri Numeral Cipher
Challenge No. 397: Tri Numeral Alphabet Cipher – English alphabets are divided into groups containing 3 alphabets each and last group contain only 2 alphabets i.
Solved using: Python in Excel.
Distance Matrix Between Cities
Challenge No. 160: x, y coordinates are given for different cities.
Solved using: Python in Excel.
Count Inversions in Number Sequence
Challenge No. 396: Let’s say i and j are positions and e(i) and e(j) are elements from the string at that position.
Solved using: Python.
Validate Point Connectivity Rule
Challenge No. 395: Coordinates for points are given in x, y format.
Solved using: DAX.
Fill Missing Months Default
Challenge No. 159: For a give name and year combination, if a month is missing between 1 and 12 then enter that month number with a default sales of 100.
Solved using: Python in Excel.