Challenge No. 386: Extract the numbers from the string if ONLY numbers are contained within the parentheses.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Render Provided Grid Design
Challenge No. 385: Generate the given grid.
Solved using: R.
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.
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.
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.
Leave Days by Priority
Challenge No. 152: The table contains dates of only one year.
Solved using: R.
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.
Numbers With Larger Successors
Challenge No. 379: List all the numbers where all succeeding numbers are larger than the number.
Solved using: Python.