Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
TEXTJOIN
Concatenates text from multiple cells using a delimiter in Excel.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Merge and Sort Name Rows
Challenge No. 606: Merge rows on the basis of names.
Solved using: Python.
Missing Letters and Frequencies
Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.
Three Regex Pattern Tasks
Challenge No. 552: This time 3 challenges into one to hone your regex skills.
Solved using: Python in Excel.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
Tap Code Cipher Generator
Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.
Odd Numbers in Matrix
Challenge No. 546: List the odd numbers reading rows from left to right and columns from top to bottom.
Solved using: Python.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.