Challenge No. 127: Find out the Zodiac signs for table T1 from Table T2.
Solved using: DAX.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
Network Days Between Year-Months
Challenge No. 124: Calculate the Network Days Count between given Months.
Solved using: Python in Excel.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Group Data Within Sale Limit
Challenge No. 119: Divide the data into groups sequentially such that sum of Sale in a group should not exceed 20 and should be as close to 20 as possible in a group.
Solved using: Python in Excel.
Custom Grouping! Part 17
Challenge No. 187: Group the rows until encountering a missing date.
Solved using:Excel (DROP, GROUPBY, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Divide Payment Across Quarters
Challenge No. 117: Equally divide the payment over current quarter and next 3 quarters.
Solved using: Python in Excel.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Forecast Monthly Rounded Growth
Challenge No. 116: Prepare the forecast from Jul onwards.
Solved using: Python in Excel.
Match Dates!
Challenge No. 183: In the question table, the dates are provided in various formats.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Google Sheets, Power Query (Text.Split, Table.Distinct, Table.TransformColumns), Python, Python in Excel, and R.
Add Index Column! Part 6
Challenge No. 182: In the question table, assign an index to the blank cells, starting from 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Combine, List.Split, List.Transform), Python, Python in Excel, and R.