Challenge No. 32: — This is the last problem in the series of FIFA world cup challenges.
Solved using: SQL.
Top Countries by Medals
Challenge No. 117: Gold, Silver and Bronze have weightage of 4, 2 & 1 respectively.
Solved using: SQL.
Sort by Type and Case
Challenge No. 116: Sort the strings within the cells.
Solved using: SQL.
Lookup Unique Set of Duplicates
Challenge No. 27: Extract Products with a Unique Set of 3 Customers in the whole dataset
For Example, Product A & D has a duplicate set of the 3 customers Dynamic array function allowed but Extra marks for Legacy solutions
or PowerQuery Solution.
Solved using: Python in Excel.
Find Beautiful Binary Strings
Challenge No. 115: A binary string is beautiful if it contains both 0 & 1 alternately.
Solved using: SQL.
Matching Tables!
Challenge No. 107: In a survey, 10 questions were asked to both
a manager and an expert, and they responded
to some of them.
Solved using:Excel (CHOOSECOLS, FILTER, HSTACK), Google Sheets, Power Query (List.PositionOf, List.Transform, Table.AddColumn), Python, Python in Excel, and R.
Extract Top Number Groups
Challenge No. 114: Extract the group of numbers from A2:A11 and list the top 3 unique maximum and minimum numbers.
Solved using: SQL.
Identify FIFA father-son pairs by
Challenge No. 31: — This is the second last problem in the series of FIFA world cup challenges —
Identify the father son duo from the data set of FIFA World cups (some data changed).
Solved using: SQL.
Sort Planets and Data
Challenge No. 113: Sort the planets first and then sort the data in respective rows
Note – I have updated the file but picture will continue to show wrong data.
Solved using: Python in Excel.
Find Non-Common Words
Challenge No. 112: Find the words which are not common between Group 1 and Group 2.
Solved using: SQL.