Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
SORT
Sorts an array in ascending or descending order in Excel.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Check ingredient availability for dishes
Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Animal Park Presence Matrix
Challenge No. 586: List all animals and all parks.
Solved using: Python.
Find Time Extremes by Date
Challenge No. 582: For different dates, document the min and max time and corresponding employees.
Solved using: Python in Excel.
Top Three Column Products
Challenge No. 578: Find the top 3 max product from the combination of numbers from 3 columns (Number1, Number2, Number3).
Solved using: Python.
Sort Consonants Keep Vowels
Challenge No. 576: Sort the consonants in given sentences while keeping the vowels wherever they are.
Solved using: Python.
Sort Odd Position Values
Challenge No. 574: Keep the numbers in even positions as it is and sort the numbers in odd positions.
Solved using: R.
Populate the addresses for Greek
Challenge No. 264: Populate the addresses for Greek alphabets appearing in the grid.
Solved using: Python in Excel.