Challenge No. 178: Create a corresponding row in result table if there is a change in either role or org.
Solved using: R.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Decode Color Band Resistance
Challenge No. 420: For the given color bands in Column E, work out the total resistance.
Solved using: Python in Excel.
Pivot for Time Entries by Date
Challenge No. 418: Pivot the given table for Date / Emp ID combinations with Min and Max Time.
Solved using: Python in Excel.
Generate Number Outline Sequence
Challenge No. 416: Generate the number outlining.
Solved using: R.
Cyclops and Triangular Numbers
Challenge No. 415: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits and >=3 digits).
Solved using: Python in Excel.
Stack and Transform Columns
Challenge No. 171: Transpose given problem table into result table.
Solved using: Python.
Weekday Weekend Sales Report
Challenge No. 170: Calculate the sum of sale for Weekdays and Weekends.
Solved using: Python in Excel.
Department Totals and Summary
Challenge No. 165: Insert the total row containing count of employees and sum of salary at the bottom of each dept groups.
Solved using: R.
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.
Leave Days by Priority
Challenge No. 152: The table contains dates of only one year.
Solved using: R.