Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python in Excel.
TEXTAFTER
Extracts the text after a specified delimiter in Excel.
Matches With Equal Goal Difference
Challenge No. 290: List the matches where goal difference is same.
Solved using: Python in Excel.
Teams With No Losses
Challenge No. 280: List the Teams which have never lost even a single game.
Solved using: Python in Excel.
Time Zone!
Challenge No. 166: In the provided table, the Date Time values correspond to different time zones (specified in the column GMT From).
Solved using:Excel (BYROW, HSTACK, LAMBDA), Google Sheets, Power Query (Text.End), Python, Python in Excel, and R.
Extract From Text! Part 3
Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Generate Italian Fiscal Code
Challenge No. 102: This is first part of 2 parts Italian Fiscal Code (Codice Fiscale) generation challenges.
Solved using: SQL.
Match Output to Picture
Challenge No. 83: Generate the output as shown in picture.
Solved using: SQL.
Find Duplicate Surnames
Challenge No. 67: List down the first ladies’ names where surnames (i.
Solved using: Power Query.
Second Words Start with C
Challenge No. 12: List the words where second word starts with C.
Solved using: Python in Excel.
Coin Change Problem!
Challenge No. 70: Consider a set of coin denominations as: {1$, 2$, 5$, 10$}.
Solved using:Excel (FILTER, LAMBDA, LET), Power Query (List.Transform, Table.FromRows), Python, R, and VBA.