Challenge No. 51: Provide a formula to calculate the total (sum) years of tenure of all US presidents.
Solved using: Power Query.
LEN
Returns the length of a text string in Excel.
Check Word Anagram Pair
Challenge No. 50: An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, using all the original letters exactly once.
Solved using: Power Query.
Digits in Increasing Sequence
Challenge No. 49: Provide a formula to list those numbers in A2:A10 where every succeeding digit is >= previous digit.
Solved using: Python in Excel.
Sort Cities on Reversed Prefix
Challenge No. 48: Sort (case insensitive) the cities on the basis of first word of the city names and sorting should be done on the basis of first word read backward i.
Solved using: Power Query (Table.AddColumn, Table.Sort).
Longest Palindromic Word
Challenge No. 47: Palindromes are those words which are same even when read from backwards.
Solved using: Python in Excel.
Find Common Letters Between Words
Challenge No. 40: Provide a formula to find common unique alphabets between 2 cells in same row.
Solved using: Power Query.
Toggle Alphabet Case
Challenge No. 36: Provide a formula to reverse the case of English alphabets.
Solved using: Power Query.
Creating the Stem & Leaf Report
Challenge No. 1: Create a Stem & Leaf Plot
Strictly Legacy Array Functions or PowerQuery
NB:
A Stem and Leaf Plot is a special table where each data value is split into a “stem” (the first digit or digits) and a “leaf” (usually the last digit).
Solved using: Excel VBA.
Extract last group of digits from string
Challenge No. 34: Extract the last group of numbers from a given string.
Solved using: Python in Excel.
Repeated Letters in Cities
Challenge No. 30: Provide a formula to list the alphabets repeated in given cities.
Solved using: Power Query.