Challenge No. 111: Fill in the individuals in Ind columns and their positions in Team Members in Ind_Pos columns.
Solved using: Python in Excel.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Fill Alphabets in Pattern Columns
Challenge No. 110: Fill in the alphabets from Names column in Name1.
Solved using: Python in Excel.
Prime Factors!
Challenge No. 178: Find the prime Factors of numbers in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, Python in Excel, R, and VBA.
Add Time to Duration Format
Challenge No. 105: Add Text Time and Add columns together and present result in duration format i.
Solved using: Excel VBA.
Filter!
Challenge No. 174: In the question table, filter out rows where there is a greater value within the two days before or after the current row.
Solved using:Excel (AND, FILTER, IF), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
Transpose Team Problem Table
Challenge No. 103: Transpose the problem table into result table.
Solved using: Power Query (Table.SelectRows).
Performance!
Challenge No. 172: In this challenge, 250,000 rows of hourly historical data are provided, which are not sorted in any specific order.
Solved using:Excel (DROP, LET, SORT), Google Sheets, Power Query (Table.AddColumn, Table.Sort), Python, Python in Excel, and R.
Unique Combinations Matching Sum
Challenge No. 284: Find out unique combination of numbers from column A containing N numbers given in column B which sums to column C.
Solved using: Python in Excel.
Custom Grouping! Part 13
Challenge No. 165: Based on monthly transactions, categorize each customer for each month into one of the following groups:
New: A customer who has never made a purchase in previous months.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group, List.Difference, List.Distinct), Python, and R.
Extract From Text! Part 6
Challenge No. 164: In Power Query, a list is defined by { } and can contain sublists, such as {1, 2, {3, 4}}.
Solved using:Excel, Google Sheets, Power Query, Python, and R.