Challenge No. 594: Work out the indexes where capital letters are.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays in Excel.
Missing Letters and Frequencies
Challenge No. 589: From the list of longest words in English, list the missing alphabets from English language and also the alphabet whose frequency is the highest (in sorted order).
Solved using: Python in Excel.
Repeat Vowels by Position
Challenge No. 587: Repeat the vowels as per their order of occurrence.
Solved using: Python in Excel.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.
Digit Sum in Fibonacci Sequence
Challenge No. 580: Let’s code golf.
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.
Digit-Constrained Product Numbers
Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.
Swap Letters by Index Pair
Challenge No. 570: For a given string, interchange the alphabets by swapping positions given in Numbers column.
Solved using: Python in Excel.
Absolute Alphabet Frequency Difference
Challenge No. 569: Find the count of alphabets in String1 and String2 and take the absolute difference of count of common alphabets and retain the non-common ones, combine those alphabets along with their counts (sorted alphabetically).
Solved using: Python in Excel.