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.
⭐️⭐️ Easy
Slightly challenging problems for learners.
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.
Toggle Alphabet Case
Challenge No. 36: Provide a formula to reverse the case of English alphabets.
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.
Price List!
Challenge No. 87: The question tables provide product price lists on various dates and transaction records.
Solved using:Excel (FILTER, LAMBDA, LOOKUP), Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
Extract last group of digits from string
Challenge No. 34: Extract the last group of numbers from a given string.
Solved using: Python in Excel.
Repeated Letters in Cities
Challenge No. 30: Provide a formula to list the alphabets repeated in given cities.
Solved using: Power Query.
Dynamic Result Table Generation
Challenge No. 10: (Excel formulas also welcome)
Generate Result table as shown.
Solved using: Power Query (Table.AddColumn, Table.SelectRows, Table.Sort).
Filter Candidates by Skill Match
Challenge No. 27: A1:C9: List of candidates with their primary and secondary skills.
Solved using: Power Query (List.Intersect, Text.Split).