Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
MAP
Applies a function to each element of one or more arrays in Excel.
Rank Regions by Yearly Scores
Challenge No. 431: Rank regions on the basis of values given for each year and list the regions for maximum occurrences of Rank 1, 2 and 3 in different years.
Solved using: Python in Excel.
Find Missing Pythagorean Quadruple
Challenge No. 429: A Pythagorean quadruple is a set of 4 integers a, b, c, d such that d^2 = a^2+b^2+c^2.
Solved using: Python in Excel.
Validate Chinese National IDs
Challenge No. 428: Chinese National ID Card Validation
The Chinese National ID Card is of 18 digits and has the format NNNNNN-YYYYMMDD-NNN-C (- is inserted for the sake of brevity, numbers will be without -).
Solved using: Python.
Double Accumulated Cipher Encoding
Challenge No. 427: Double Accumulate Cipher
Step 1.
Solved using: Python.
Blend RGB Colors into Hex
Challenge No. 425: To blend hex color, take the average (round to 0) of respective Rs, Gs and Bs of two colors and generate the Hex color for the result.
Solved using: Python in Excel.
Insert Product Between Digits
Challenge No. 424: Take ith and (i+1)th digits, multiply them and insert the result between the same digits.
Solved using: Excel VBA.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.