Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Match Deliveries with Calendar Dates
Challenge No. 186: Merge both the tables.
Solved using: Python in Excel.
Extract Ending Pattern Group
Challenge No. 184: Extract the last group of alphabets followed by numbers in each Text and concat them with a dash in between for each Set.
Solved using: Python.
Max Monthly Sales Change
Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.
Find Disagreeing Leap Years
Challenge No. 422: Revised Julian Calendar Leap Year Rules
1.
Solved using: Python in Excel.
Track Org Role Changes
Challenge No. 178: Create a corresponding row in result table if there is a change in either role or org.
Solved using: R.
Find Reverse-Divisible Non-Palindromes
Challenge No. 419: Reverse a number.
Solved using: Python in Excel.
Split and Running Total Rows
Challenge No. 176: Generate the result table from problem table.
Solved using: Python in Excel.
Generate Number Outline Sequence
Challenge No. 416: Generate the number outlining.
Solved using: R.
Render ASCII US Flag
Challenge No. 404: Generate US ASCII flag.
Solved using: Python.