Challenge No. 417: Split the given strings whenever a changeover happens between English alphabets and numbers.
Solved using: Excel VBA.
By Topic
Challenges categorized by topic.
Validate IMO Check Digit
Challenge No. 414: IMO Number of a Vessel – This is a 7 digit number where last digit is check digit.
Solved using: Python in Excel.
Pivot Using Suffix Headers
Challenge No. 413: Pivot the given data with headers suffixed with 1, 2.
Solved using: Python.
Pivot Table by Agent
Challenge No. 173: Pivot the given table as shown.
Solved using: Python.
Calculate Agent Commission Totals
Challenge No. 172: Find the total commission paid to each agent along with a Grand Total row.
Solved using: R.
Normalize Table from Merged Cells
Challenge No. 409: This challenge was contributed by Taeyong Shin
Unmerge merged cells, separate characters separated by delimiters, and create a normalized table.
Solved using: Python in Excel.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
Encrypt Using Vigenere Cipher
Challenge No. 402: Vignere Cipher – Write the plain text (p) and keyword (k) beneath that.
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.
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.