Challenge No. 440: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.
⭐️⭐️⭐️⭐️ Advanced
Complex challenges for experienced users.
Find Interpolated Grid Values
Challenge No. 439: Today’s challenge is proposed by Sunny Baggu
a is for row 1 and b is for column 1.
Solved using: Python in Excel.
Quarterly Hike Compounding Table
Challenge No. 183: Transpose the problem table into result table.
Solved using: Python in Excel.
Family Relationship Tree View
Challenge No. 175: List the Names along with the Names of next generation and relationship between generations.
Solved using: Python.
Pivot Table by Agent
Challenge No. 173: Pivot the given table as shown.
Solved using: Python.
Encrypt Using Vigenere Cipher
Challenge No. 402: Vignere Cipher – Write the plain text (p) and keyword (k) beneath that.
Solved using: Python in Excel.
Extract Alphabet Number Pairs
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.
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.
List Super-Palindrome Numbers
Challenge No. 394: A palindrome number is that which is same even where read backwards.
Solved using: Python in Excel.
Extract Valid Time Entries
Challenge No. 155: Extract the valid times from the given strings.
Solved using: Python in Excel.