Challenge No. 30: Extract the LAST Correct Order
These are numbers/symbols following the last alphabet letter.
Solved using: Python in Excel.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Top Words in Presidents
Challenge No. 123: Column A contains list of US presidents.
Solved using: SQL.
Add Large Text Numbers
Challenge No. 122: Add Number1 and Number 2 together.
Solved using: Python in Excel.
Calculate Digital Root
Challenge No. 121: Calculate Digital root of the given numbers.
Solved using: Python in Excel.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
Reverse Concatenation Order
Challenge No. 120: Where Tn = T(n-2) & T(n-1) and & was concatenation operator.
Solved using: SQL.
Signed Binary to Decimal
Challenge No. 118: Convert binary numbers into decimal numbers.
Solved using: Python in Excel.
Top Countries by Medals
Challenge No. 117: Gold, Silver and Bronze have weightage of 4, 2 & 1 respectively.
Solved using: SQL.
Extract Top Number Groups
Challenge No. 114: Extract the group of numbers from A2:A11 and list the top 3 unique maximum and minimum numbers.
Solved using: SQL.
Sort Planets and Data
Challenge No. 113: Sort the planets first and then sort the data in respective rows
Note – I have updated the file but picture will continue to show wrong data.
Solved using: Python in Excel.