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.
MAP
Applies a function to each element of one or more arrays in Excel.
Extract Valid Year Ranges
Challenge No. 702: Extract the years from the given data.
Solved using: Python in Excel.
Pivot with Total Line
Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Remove One Letter Palindrome
Challenge No. 699: Only one alphabet can be removed from Words list and it should become a palindrome.
Solved using: Python.
Repeat Non-Consecutive Characters
Challenge No. 694: Repeat every character in the string except those characters which appear consecutively.
Solved using: R.
Assign Rank1 and Rank2
Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
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.
Fill Cell With Max Right-Down
Challenge No. 687: Fill in the blank with max of (max of remaining cells of row going to right and max of remaining cells of column going down).
Solved using: Python in Excel.
Detect Overlapping Tasks
Challenge No. 685: List the tasks which are overlapping.
Solved using: Python in Excel.
Grid Lookup By Pattern
Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.