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.
FILTER
Filters an array based on given criteria in Excel.
Team with All Wins
Challenge No. 692: List the team which won all their matches.
Solved using: Python in Excel.
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.
Align Names With Amounts
Challenge No. 684: Align Name and amounts together as shown.
Solved using: R.
Even-Odd Reversed Squares
Challenge No. 678: Find first 50 numbers (at least 2 digits) where
1.
Solved using: Python.
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.
Word Pairs With All Vowels
Challenge No. 671: Find the pair of words which together contain all 5 vowels.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
First Ten Tech Numbers
Challenge No. 669: Tech Number – A number is a tech number if it has even number of digits and square of sum of first half and last half is equal to number itself.
Solved using: R.