Challenge No. 441: Generate the integers corresponding to intervals.
Solved using: Python.
VSTACK
Stacks arrays vertically into a single column in Excel.
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.
Yearly Sales for All Continents
Challenge No. 187: Generate the result table from problem table.
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.
Split Delimited Text into Columns
Challenge No. 433: Split the given text into columns.
Solved using: R.
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.
Quarterly Hike Compounding Table
Challenge No. 183: Transpose the problem table into result table.
Solved using: Python in Excel.
Reverse Data Splitting Problem
Challenge No. 182: Let’s do reverse of yesterday’s problem.
Solved using: Python.
Max Monthly Sales Change
Challenge No. 180: List the total sales, maximum change in sales month on month basis (absolute value) and From and To months when this maximum change occurred.
Solved using: Python.
Sales Year Monthly Summary
Challenge No. 179: Generate the result table from problem table.
Solved using: R.