Challenge No. 126: Combine Series 1 and Series 2 together and sort them and list those where elements of the combined series are in sequence with no gap.
Solved using: SQL.
MAX
Returns the largest value in a range in Excel.
List max frequency alphabets across
Challenge No. 33: Generate the answer as shown.
Solved using: SQL.
Top Countries by Medals
Challenge No. 117: Gold, Silver and Bronze have weightage of 4, 2 & 1 respectively.
Solved using: SQL.
Count Palindromes in Range
Challenge No. 107: Palindrome numbers are those which are same even when read from backwards.
Solved using: Python in Excel.
Calculate Turnaround Time
Challenge No. 96: Calculate the Turn Around Time (TAT) i.
Solved using: Python.
Region-Year with Max Growth
Challenge No. 87: Find the Region and Year where and when the growth was the highest.
Solved using: DAX.
Best and Worst Rank Changes
Challenge No. 77: — This week will be FIFA World Cup week.
Solved using: SQL.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.
Find Last Group of Missing Numbers
Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.
List Longest Words in Sentence
Challenge No. 19: Provide a formula to list longest words in sentences given in A2:A10.
Solved using: Python in Excel.