Challenge No. 435: Draw the given boat..
Solved using: Excel VBA.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Generate Excel Column Headers
Challenge No. 434: Generate the columns headers of Excel in a 20×5 matrix as shown.
Solved using: Python.
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.
Encrypt with Bifid Cipher Method
Challenge No. 432: Bifid Cipher
Suppose we want to encrypt the message “BATTLE”.
Solved using: Python in Excel.
Rank Regions by Yearly Scores
Challenge No. 431: Rank regions on the basis of values given for each year and list the regions for maximum occurrences of Rank 1, 2 and 3 in different years.
Solved using: Python in Excel.
Create Alphabetic Searchlight Grid
Challenge No. 430: Create an alphabetic searchlight as shown.
Solved using: Python in Excel.
Validate Chinese National IDs
Challenge No. 428: Chinese National ID Card Validation
The Chinese National ID Card is of 18 digits and has the format NNNNNN-YYYYMMDD-NNN-C (- is inserted for the sake of brevity, numbers will be without -).
Solved using: Python.
Double Accumulated Cipher Encoding
Challenge No. 427: Double Accumulate Cipher
Step 1.
Solved using: Python.
Evaluate Tic Tac Toe Results
Challenge No. 426: Find the results of given Tic Tac Toe (Noughts and Crosses) boards.
Solved using: Python.
Insert Product Between Digits
Challenge No. 424: Take ith and (i+1)th digits, multiply them and insert the result between the same digits.
Solved using: Excel VBA.