Easy challenges for newcomers.
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.
Challenge No. 115: A binary string is beautiful if it contains both 0 & 1 alternately.
Solved using: SQL.
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.
Challenge No. 111: Generate all the numbers between From and To.
Solved using: SQL.
Challenge No. 110: Generate the result table.
Solved using: SQL.
Challenge No. 108: Reverse the rows and columns both.
Solved using: SQL.
Challenge No. 106: Get the data for all shops corresponding to latest date as shown in the result table.
Solved using: Python in Excel.
Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
Challenge No. 24: Put the applicants on either shortlist, longlist or disqualify them
Use the required technologies for long or shortlist
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
