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.
UNIQUE
Returns unique values from a range or array in Excel.
Pivot with Total Line
Challenge No. 700: Pivot the given data by summing up the values.
Solved using: Python.
Team with All Wins
Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
Assign Rank1 and Rank2
Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
Sum of Values for Alphabets
Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
Detect Overlapping Tasks
Challenge No. 685: List the tasks which are overlapping.
Solved using: Python in Excel.
Distribute Consecutive Numbers
Challenge No. 674: This challenge has been contributed by Mehmet Çiçek
List consecutive numbers into different columns.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Pivot Data To Columns
Challenge No. 667: Pivot the data as shown.
Solved using: Python.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.