Challenge No. 559: For all columns, find the max in a cell considering its range from 1st cell till that cell.
Solved using: Excel VBA.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Pivot the problem table into
Challenge No. 251: Pivot the problem table into result table.
Solved using: Python.
Calculate Finish Stock and Starting
Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
First and Last Number Sum
Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
Top Two Department Salaries
Challenge No. 543: Find out the top 2 salaries in all departments.
Solved using: Python in Excel.
For each Deal, list the
Challenge No. 246: For each Deal, list the name of the persons who handled the deal most recently.
Solved using: Python.