Challenge No. 72: Create Weekly Date Groups and Sum
A Week runs from Monday to Sunday
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
By Topic
Challenges categorized by topic.
Clean Salary and Promotion Data
Challenge No. 226: Clean the given data and align them properly in departments and sort on Dept ID & Names.
Solved using: Python in Excel.
Decrypt Pig Latin Words
Challenge No. 511: Pig Latin Decrypter – Decrypt the given encrypted text where encryption logic was following –
A new encrypted word is created with 3 components –
Component 1 – String having all alphabets from first vowel occurrence till end of the word
Component 2 – String having all alphabets before first vowel occurrence
Component 3 – String “ay”
Anything other than the English alphabet will be left as it is.
Solved using: Python in Excel.
Check Lexically Sorted Dates
Challenge No. 507: List the dates which are lexically sorted.
Solved using: Python.
Hierarchical Project Indexing
Challenge No. 221: Do the Indexing for project, task and activity.
Solved using: Python.
Mark Completed Tasks Only
Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
Index Range Closest to 100
Challenge No. 493: List the Start and End Indexes where sum of numbers <=100 with minimum gap between sum of numbers and 100. Solved using: R.
Date Cipher Decryption
Challenge No. 492: DATE CIPHER DECRYPTER – Decrypt the given messages which were encrypted using following logic.
Solved using: Python in Excel.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.
Extract Date Day and Time
Challenge No. 68: Extract the Date, Day of the Week and Time
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solutions.
Solved using: R.