Challenge No. 703: Today’s challenge is contributed by Duy Tùng
It is required to calculate the total for each employee over consecutive (or separate) days and take the maximum value.
Solved using: Python.
DROP
Removes a specified number of rows or columns from an array in Excel.
Pivot with Total Line
Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Fill Missing Monthly Values
Challenge No. 698: Populate all months of the year.
Solved using: Python.
Evaluate Student Subject Status
Challenge No. 697: Document Pass or Fail against all students.
Solved using: Python in Excel.
Repeat Non-Consecutive Characters
Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.
Sum Without First And Last
Challenge No. 688: Sum all the numbers given in column A except the first and last numbers in every cell.
Solved using: R.
Align Custom Data Layout
Challenge No. 686: This problem is contributed by RIJESH THOMAS
Align the data as shown.
Solved using: Python in Excel.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
Split And Sum Orders
Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.
Split And Align Columns
Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.