Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.
LOOKUP
Finds a value in a one-row or one-column range in Excel.
Encrypt Text with Keyword Cipher
Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.
Convert Marks to Grade Points
Challenge No. 375: Calculate the grade points for given marks.
Solved using: Python in Excel.
Map Groups to Company
Challenge No. 137: Generate result table on the basis of 2 problem tables.
Solved using: Python in Excel.
Replace letters with nearest vowels
Challenge No. 346: The string contains only English alphabets.
Solved using: Python in Excel.
Daily Stock Closing Value
Challenge No. 134: Yesterday’s challenge was a tough one.
Solved using: Python in Excel.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Hierarchical Structure!
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Fill Down using dynamic arrays.
Challenge No. 47: Add the opening stock to each recorded stock during the day
Note that this is not a running total but a stock adjustment
For example, the last recording on the 10th is 201, i.
Solved using: Python in Excel.
Lookup and Sum
Challenge No. 44: Summarise the budget per Department
For example, Using the Lookup table, the total Finance budget is
“Treasury (278)+Budgeting (748)”.
Solved using: Python.