Challenge No. 16: Sum the total sales of the visible cells
NB: Include all “MILK” Product
Dynamic array function allowed but
Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Crispo Challenges
Including all the Excel Power BI Power Query Python R challenges designed by Crispo Mwangi.
Advanced Lookup Data Separated by a Carriage Return
Challenge No. 15: Extract the least performed subject and marks
Dynamic array function allowed
but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Lookup and Get the Difference
Challenge No. 14: Rules:
Check Salary within Scale Table
If Exact within the table, (Salary-previous year Amount)
If between 2 years, get the difference between the two years
If No Previous Year, Return Zero
Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Clean and Sum a Text String
Challenge No. 13: Calculate the remaining visits
Strictly Legacy array function or PowerQuery.
Solved using: Python in Excel.
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.
Create Number Blocks From a Text String
Challenge No. 11: Create blocks based on the sets of text number strings.
Solved using: Power Query.
Extract and Format a Text String
Challenge No. 8: Extract and format the voucher number
Strictly Legacy array function or PQ
Nelson Mwangi.
Solved using: Power Query.
Return a Date given the Month, Year, Day of the Week and Occurrence
Challenge No. 7: Return a Date given the Month, Year, Day of the Week and Occurrence Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Split and Sum a Text String Using a Criteria
Challenge No. 10: Sum only quantities above 100
Strictly use the Legacy array function or Power Query.
Solved using: Power Query.