Challenge No. 384: Take position 1 in given number as first slice (I am following index 1 notation of Excel not index 0) and cut the slice starting from position 2 in such a way that the slice is > previous slice.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Extract Signed Numbers from Text
Challenge No. 383: Extract the unique positive and negative numbers if they are immediately preceded by either plus or minus sign.
Solved using: Python.
Generate Kamasutra Cipher Encryption
Challenge No. 382: Kamasutra Cipher – Generate 13 random pairs from English alphabets and use that to encrypt the plain text.
Solved using: Python.
Pilot Flight Rest Hours
Challenge No. 153: This time this problem will appear on both Sat and Sun with variations.
Solved using: Python in Excel.
Draw Square With X Pattern
Challenge No. 380: Draw an N x N square where sides and diagonals are filled with x.
Solved using: Python.
Leave Days by Priority
Challenge No. 152: The table contains dates of only one year.
Solved using: R.
Numbers With Larger Successors
Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.
Split on First Greater Sum
Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
Encrypt Text with Keyword Cipher
Challenge No. 377: Encrypt the gives words using Keyword Cipher.
Solved using: Python.
Fill Missing Time Fields
Challenge No. 150: You need to fill in the blanks.
Solved using: Python.