Challenge No. 29: Extract Staff who only attended 1 training
Dynamic array function allowed, but Extra
marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Custom Grouping! Part 3
Challenge No. 109: Dates were grouped by sales trends, with each group extending until a drop in sales occurred.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Add Large Text Numbers
Challenge No. 122: Add Number1 and Number 2 together.
Solved using: Python in Excel.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
Calculate Digital Root
Challenge No. 121: Calculate Digital root of the given numbers.
Solved using: Python in Excel.
Reverse Concatenation Order
Challenge No. 120: Where Tn = T(n-2) & T(n-1) and & was concatenation operator.
Solved using: SQL.
Extract Complete Data
Challenge No. 28: Extract the LAST 5 complete records
Minimize on functions used
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Trim Underscores at Ends
Challenge No. 119: Remove the trailing and leading underscore characters.
Solved using: SQL.
Avg Cooperation Time!
Challenge No. 108: Calculate the average cooperation time in months for those who are still with the company (do not have value on column leave date) as of 16/08/2024, categorized by their respective levels.
Solved using:Excel (AVERAGE, FILTER, HSTACK), Google Sheets, Power Query (Date.Month, Date.Year), Python, Python in Excel, and R.
Signed Binary to Decimal
Challenge No. 118: Convert binary numbers into decimal numbers.
Solved using: Python in Excel.