Challenge No. 6: Get the most popular fruit in the 5 stalls:
Rule: Strictly, Strictly Legacy array function or Power Query.
Solved using: Power Query.
Crispo Challenges
Including all the Excel Power BI Power Query Python R challenges designed by Crispo Mwangi.
Sum Every Nth Occurrence based on a Criteria Challenge
Challenge No. 4: Sum Every Nth Occurrence per payment if the project meets the criteria
Strictly Legacy Array Functions or PowerQuery
Note:
Every payment has 5 occurrences.
Solved using: Power Query.
Return the Most Recent Day of Week
Challenge No. 5: Return a Date of the most recent/next day of the week starting from Today
Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.
Counting Days of the Week Between Dates
Challenge No. 2: Count the number of days between two dates
Strictly Legacy Array Functions or PowerQuery
Hazem Hassan.
Solved using: Power Query.
Lookup Data with a Carriage Return Delimiter
Challenge No. 3: Extract the top marks attained
Use strictly legacy array functions or power query.
Solved using: Power Query.
Creating the Stem & Leaf Report
Challenge No. 1: Create a Stem & Leaf Plot
Strictly Legacy Array Functions or PowerQuery
NB:
A Stem and Leaf Plot is a special table where each data value is split into a “stem” (the first digit or digits) and a “leaf” (usually the last digit).
Solved using: Excel VBA.