Challenge No. 604: Today’s problem is contributed by Ahmad Syawal Ramli
Generate the area enclosed in red from problem table.
Solved using: Power Query.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Find Smallest Uncreatable Sum
Challenge No. 600: What is the smallest sum which you can’t create using all or few of the coins given?
Ex.
Solved using: Python in Excel.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Draw a Pentagram Symbol
Challenge No. 597: Prepare a Pentagram..
Solved using: Python.
Calculate Monthly Day Totals
Challenge No. 595: This challenge is contributed by 🇰🇷 Taeyong Shin
Create a table that calculates the number of weekdays, Saturdays, and Sundays using yearly and monthly data, and displays the total number of days in each month.
Solved using: Python in Excel.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Generate Bell Number Triangle
Challenge No. 592: Prepare Bell Triangle for given n where n is number of rows.
Solved using: Python.
List Consecutive Streak Indexes
Challenge No. 590: If there are more than one consecutive streaks of H or T, then list the Indexes of those.
Solved using: Python in Excel.
Rank stores by percentage of
Challenge No. 263: Table 1 (T1) has got customer satisfaction responses and Table 2 (T2) has got color coding of those responses.
Solved using: Python.
Digit-Constrained Product Numbers
Challenge No. 571: Find the first 500 numbers starting with 10 where number multiplied by its reversed digits contain only those digits which are there in the number.
Solved using: Python.