Challenge No. 331: List those numbers which can be expressed as the sum of cube of two numbers.
Solved using: Python in Excel.
⭐️ Beginner
Easy challenges for newcomers.
List words longer than average word length
Challenge No. 330: Extract all the words which are greater than average length of the words in that sentence.
Solved using: R.
Remove last occurrence of minimum number
Challenge No. 328: — Looks like scheduling didn’t work today and challenge didn’t get posted—
Remove the last minimum number from given strings.
Solved using: Python in Excel.
Text Split
Challenge No. 57: Split the group of texts into single characters
Dynamic array function allowed, but extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Top 3 marks with names and subjects
Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.
Custom Grouping! Part 18
Challenge No. 193: Separate sales into weekday sales (Mon-Fri) and weekend sales (Sat-Sun).
Solved using:Excel (DAY, FILTER, GROUPBY), Google Sheets, Power Query (Table.Group, Date.DayOfWeek, Table.AddColumn), Python, Python in Excel, and R.
List numbers not in Fibonacci sequence
Challenge No. 326: List the numbers which are not a Fibonacci number.
Solved using: Python in Excel.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
List subjects appearing within +/-1 row in column B
Challenge No. 324: List the subjects from column A which appear in column B within +1 or -1 position to column A.
Solved using: DAX.
Find palindromic substrings with at least 3 digits
Challenge No. 323: Find the substrings of given numbers which are Palindromic.
Solved using: DAX.