Challenge No. 124: In Question Table 1, dates and prices for a product are provided.
Solved using:Excel (INDEX, LAMBDA, LET), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
MIN
Returns the smallest value in a range in Excel.
Check Sequential Series
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.
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.
Minimize Absolute Value Difference
Challenge No. 44: Find the numbers where absolute difference between Number1 and Number2 in a row is minimum.
Solved using: Python in Excel.
Find Last Group of Missing Numbers
Challenge No. 42: Provide a formula to find last group of missing numbers.
Solved using: Power Query.
Find Missing Numbers!
Challenge No. 52: In the Question Table, numbers ranging from 1001 to 1018 are listed.
Solved using:DAX, Excel (COUNTIF, FILTER, IF), Power Query (List.Difference), Python, Python in Excel, R, SQL, and VBA.
Assignment Problem (Part 2)!
Challenge No. 50: In the continuation of the previous challenge, we reach the question table as the normalized table, in the rest of the algorithm the below step should be done.
Solved using:Excel (AND, BYCOL, BYROW), Power Query (List.Transform, Table.Column), Python, and R.
Assignment Problem (Part 1)!
Challenge No. 49: Assignment Problem is a well-known problem for assigning tasks to different people by the minimum cost and we want to solve it with The Hungarian method within two challenges.
Solved using:Excel (BYCOL, BYROW, HSTACK), Power Query (List.Skip, List.Transform, Table.Column), Python, and R.