Challenge No. 67: List down the first ladies’ names where surnames (i.
Solved using: Power Query.
LAMBDA
Creates custom reusable functions in Excel.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Top Students Subject Order
Challenge No. 19: Generate Top 3 students in all subjects.
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.
Detect Repeated Digits in Numbers
Challenge No. 64: List the numbers which have got any digits repeated.
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.
Find Matches with Same Goals
Challenge No. 61: List the matches where total goals scored are same.
Solved using: Excel VBA.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.
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.
Count Prime Numbers in Range
Challenge No. 58: Count prime numbers between given Lower and Upper Limits.
Solved using: Python in Excel.