Challenges categorized by topic.
Challenge No. 195: In the ID column, the text should follow the format XX/XX/XX/XX (with a ‘/’ after every two characters).
Solved using:Excel (IF, LAMBDA, LEN), Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Challenge No. 126: Work out the dates after the dates given in column A by Reference days.
Solved using: Power Query (Table.AddColumn).
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Challenge No. 57: Split the group of texts into single characters
Dynamic array function allowed, but extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Challenge No. 193: Separate sales into weekday sales (Mon-Fri) and weekend sales (Sat-Sun).
Solved using:Excel (DAY, FILTER, GROUPBY), Google Sheets, Power Query (Table.Group, Date.DayOfWeek, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
Challenge No. 192: Any row with a negative quantity should reduce the corresponding value in the previous rows for the related product.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Table.Group, Table.SelectRows, Table.Sort), Python, Python in Excel, and R.
Challenge No. 123: Calculate Start and Finish date times along-with duration in hours for all weeks.
Solved using: Python in Excel.
Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.
Challenge No. 122: Transform the problem table into result table and work out the total number of hours a vehicle has run on a particular date.
Solved using: Power Query (List.Transform).
