Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.
⭐️⭐️ Easy
Slightly challenging problems for learners.
Filter Products by Date Range
Challenge No. 371: This problem is contributed by Mehmet Çiçek
Find the list of products (alphabetically sorted) for the date range given in columns H & I from the table given in columns A to F.
Solved using: DAX.
Encrypt Text with Multi-Tap Cipher
Challenge No. 368: Encrypt the given words using Multi Tap Cipher.
Solved using: Python.
Split Group and Track Running
Challenge No. 144: Divide the data set for a group in 2 halves.
Solved using: Python in Excel.
Extract Longest Alphanumeric Segment
Challenge No. 361: Separate out the largest sequences of English alphabets and numbers from the given strings.
Solved using: Python in Excel.
Sum of Unique Consecutive Numbers
Challenge No. 359: Express the numbers as sum of 2 or more unique consecutive numbers.
Solved using: R.
Digits with Higher Frequency
Challenge No. 356: List the digits whose frequency is > frequency of the maximum digit
Ex.
Solved using: R.
Transpose People Table
Challenge No. 138: Transpose the problem table into result table.
Solved using: R.
Reverse Words Between Indexes
Challenge No. 351: Reverse the words between two words whose both inclusive positions are given.
Solved using: Python in Excel.
Find Insolite Numbers
Challenge No. 350: List the Insolite Numbers – A number is Insolite if it is divisible by both
Sum of square of its digits AND
Product of square of its digits
Ex.
Solved using: Python in Excel.