Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
MAP
Applies a function to each element of one or more arrays in Excel.
Top Three Sales by Date
Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.
List Words with Three Vowels
Challenge No. 622: Generate the list of words which contain at least 3 different vowels.
Solved using: R.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Count Unique Uncommon Words
Challenge No. 610: Find the number of un-common unique words between Sentence1 and Sentence2.
Solved using: Python.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
Find Smallest Uncreatable Sum
Challenge No. 600: What is the smallest sum which you can’t create using all or few of the coins given?
Ex.
Solved using: Python in Excel.
Match Words in Column Data
Challenge No. 599: Look up the Words (in column D) in Column1 and list the Result from Column2.
Solved using: Python.
Reapply Original Capitalization
Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
