Challenge No. 387: For a date given in cell A1, generate the last Mon through Sun of the month
-1 : Last
-2 : 2nd Last.
Solved using: Python.
Extract Valid Time Entries
Challenge No. 155: Extract the valid times from the given strings.
Solved using: Python in Excel.
Extract Numbers Inside Parentheses
Challenge No. 386: Extract the numbers from the string if ONLY numbers are contained within the parentheses.
Solved using: Python in Excel.
Render Provided Grid Design
Challenge No. 385: Generate the given grid.
Solved using: R.
Monthly Flight Time Summary
Challenge No. 154: This problem is a variation of yesterday’s problem.
Solved using: Power Query.
Slice Numbers with Greater Rules
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.
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.
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.
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.
Shorten IPv6 with Rules
Challenge No. 381: IPv6 address is represented as x:x:x:x:x:x:x:x (total 8 x) where x consists of 1 to 4 Hexadecimal digits.
Solved using: Python in Excel.