Challenge No. 159: Reverse all columns from Cities1 to Cities5.
Solved using: Power Query (List.RemoveNull, List.Reverse, List.Transform).
⭐️ Beginner
Easy challenges for newcomers.
Top Duration Players
Challenge No. 158: List the top 3 players in decreasing order of duration.
Solved using: Python in Excel.
Find Pythagorean Dates
Challenge No. 156: Pythagorean dates are those dates where DD^2 + MM^2 = YY^2
For example: 16-Dec-2020 where 16^2 + 12 ^2 = 20^2
List all Pythagorean dates (in YYYYMMDD format) from current century.
Solved using: Python in Excel.
Polybius Cipher Encrypt
Challenge No. 155: Polybius cipher
Encrypt the text in column I as per grid in A2:G8.
Solved using: Python in Excel.
Remove Words by Index
Challenge No. 152: Remove the Words from column A as per index in column B.
Solved using: Excel VBA.
Common Digits in Row
Challenge No. 151: List the common digits between all the numbers in a row.
Solved using: Python in Excel.
Grouping Data
Challenge No. 38: Sort Cookies into 2 groups: with Duplicate Price & with Unique prices Dynamic array function allowed but
Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Perfect Numbers Detection
Challenge No. 149: List the perfect numbers from column A.
Solved using: Python in Excel.
Rotate Grid by Count
Challenge No. 148: Rotate the grid given in A4:E7 as per values given in B1.
Solved using: Power Query.
Return Repeat Customers
Challenge No. 37: Return only dates with repeat customers and repeated customers Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.