Challenge No. 451: Find the positive and negative numbers which occur consecutively maximum number of times.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Rank Sales with Tie Handling
Challenge No. 450: Assign rank on the basis of sales made by different salespersons in a company.
Solved using: Excel VBA.
Find Penholodigital Squares
Challenge No. 447: Penholodigital squares are perfect square numbers that contain digits from 1 to 9 exactly once.
Solved using: R.
Extract Valid Structured Words
Challenge No. 191: Extract the words which are either numbers followed by all uppercase English letters or vice versa.
Solved using: Python in Excel.
Generate Look-and-Say Sequence
Challenge No. 444: Look & Say Sequence
Going from Left to Right in a number, take a digit and insert how many times this digit appears to the left of the digit.
Solved using: Python in Excel.
Encrypt Using Columnar Cipher
Challenge No. 442: Columnar Transposition Cipher
Write the keyword in a row
Rank the letters of keyword as per their position in English language in descending order.
Solved using: Python in Excel.
Generate Integers From Ranges
Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
Allocate Amounts by Quarter Days
Challenge No. 188: Divide the amount across quarters falling in between From and To Date.
Solved using: Python in Excel.
Encrypt Using Bifid Cipher
Challenge No. 437: Bifid Cipher with Keyword
Suppose we want to encrypt the message “BATTLE” and keyword is “ROTORS”.
Solved using: Python in Excel.
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.