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.
Consecutive Dates Task Grouping
Challenge No. 17: (Excel formulas also welcome)
Generate the output table.
Solved using: Power Query.
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.
List 2nd and 4th Saturdays
Challenge No. 56: Provide a formula to generate the list of 2nd and 4th Saturdays for a given quarter and year in A1.
Solved using: Power Query.
Split, Multiply and Sum a Text String
Challenge No. 12: Calculate total sales
Strictly Legacy array function
Abdallah Ally Bhavya Gupta Richard Nero.
Solved using: Power Query.
Reverse Lookup
Challenge No. 9: Reverse Lookup of all the scheduled jobs, Dates and Time
Strictly Legacy Array Functions or PowerQuery.
Solved using: Python.
Generate Logical Grid Pattern
Challenge No. 55: Provide a formula to generate the given grid.
Solved using: Power Query.
Missing Values! Part 3
Challenge No. 92: In the question table, some cells (highlighted) are missing, but a character determines how to fill them based on the following rule:
R = right cell
L = left cell
U = upper cell
D = down cell.
Solved using:Excel (IF, IFS, INDEX), Power Query (List.PositionOf, List.Transform), Python, Python in Excel, and R.
Dynamic Table Generation Result
Challenge No. 16: (Excel formulas also welcome)
Generate the Result table shown.
Solved using: Power Query (List.Distinct, Table.Pivot, Table.PromoteHeaders).