Challenge No. 173: The Question table contains transactions recorded on different dates.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddIndexColumn), Python, Python in Excel, and R.
⭐️⭐️⭐️⭐️ Advanced
Complex challenges for experienced users.
Unique Dept-Name Combinations
Challenge No. 102: Prepare unique combinations of Dept and corresponding names.
Solved using: Power Query (List.Transform).
Prime with Consecutive Digits Only
Challenge No. 283: A number should contain digits only from 1 through length of that number and should also be a prime.
Solved using: Python in Excel.
Compare Store1 vs Store2 Visits
Challenge No. 96: List Customer1 whose Store1 Visit Date Time is less than or equal to Store2 Visit Date Time if they visited Store2 also.
Solved using: Power Query (Table.SelectRows).
Fix and Transpose Messy Table
Challenge No. 95: Transpose the problem table into result table.
Solved using: Power Query.
Sales Based on Custom Month Range
Challenge No. 92: The accounting month of this company finishes on last Friday of the month.
Solved using: Python in Excel.
Add Hierarchical Location Indexes
Challenge No. 88: Add the indexes for Country, State and City.
Solved using: Python in Excel.
Extract Results From Input
Challenge No. 85: Generate the result table from problem table.
Solved using: Python in Excel.
Top 3 Students Per Subject
Challenge No. 81: Generate Top 3 students in all subjects.
Solved using: Power Query.
Match Ages Using Email First
Challenge No. 78: Populate Age in Table 1 on the basis of Table 2.
Solved using: Power Query.