Challenge No. 31: Get the last order for each Month
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
⭐️ Beginner
Easy challenges for newcomers.
Add Spaces Between Types
Challenge No. 128: Insert a space whenever there is a transition from alphabet to number OR number to alphabet in the strings.
Solved using: SQL.
Compare Rows! Part 2
Challenge No. 111: In the historical sales table, extract the dates where the total sales value is greater than the total on the previous date
for example, in 2/1/2024 total sales were 14 and is greater than total sales on 1/1/2024 which is 11.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.Group, Table.SelectRows), Python, Python in Excel, and R.
Convert Strings to Morse
Challenge No. 125: Convert given strings into Morse codes.
Solved using: SQL.
Find Disarium Numbers
Challenge No. 124: List the Disarium numbers from column A.
Solved using: Python in Excel.
Lookup Uncommon Names in the set
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.
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.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.