Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
UNIQUE
Returns unique values from a range or array in Excel.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Teams Repeated in Finals
Challenge No. 73: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 2 Runner-ups Without Win
Challenge No. 72: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 4 FIFA WC Champions
Challenge No. 71: — This week will be FIFA World Cup week.
Solved using: DAX.
Find Duplicate Surnames
Challenge No. 67: List down the first ladies’ names where surnames (i.
Solved using: Power Query.
Find Consecutive Birds
Challenge No. 66: List down the birds which appear consecutively at least 2 times.
Solved using: Python in Excel.
Two-Column Text!
Challenge No. 94: In the question table, texts are provided for different groups.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Split, List.Transform, Table.ExpandTableColumn), Python, Python in Excel, and R.
Random Selection! Part 1
Challenge No. 93: Randomly select a staff member from each department.
Solved using:Excel (FILTER, HSTACK, INDEX), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Unique Animals by Column
Challenge No. 57: Provide a formula to generate the list of unique animals from columns taking one column at a time who don’t appear in any other column.
Solved using: Python in Excel.