Challenges categorized by topic.
Challenge No. 135: Find the number of occurrences of the “+-+” pattern across the test IDs for each product.
Solved using:Excel (BYROW, CONCAT, DROP), Google Sheets, Power Query (List.Range, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 199: List the count of dates along with Min and Max date for the rows in columns A & B where MM + DD = YY.
Solved using: Python in Excel.
Challenge No. 197: List the qualifying player from each group on the basis of
1.
Solved using: Power Query (Table.AddColumn).
Challenge No. 134: From the “transactions” in the provided table, filter those that occurred in the last 7 days of the month.
Solved using:Excel (CHOOSECOLS, DAY, EOMONTH), Google Sheets, Power Query (Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and SQL.
Challenge No. 57: Insert new rows for Groups to make row count for all groups equal.
Solved using: Power Query (Table.AddColumn).
Challenge No. 133: Group the monthly sales values into three categories based on the following logic and provide one of the result tables:
Group 1: 1st to 10th of the month
Group 2: 11th to 20th of the month
Group 3: 21st to the end of the month.
Solved using:Excel (DATE, DAY, DROP), Google Sheets, Power Query (Table.Group, Date.Month, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Challenge No. 192: Excel formulas permit date range from 1-Jan-1900 to 31-Dec-9999.
Solved using: Python in Excel.
Challenge No. 132: In Question Table 1, values are provided for each code.
Solved using:Excel (FILTER, FIND, ISNUMBER), Google Sheets, Power Query (Text.Contains, Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
Challenge No. 131: Transform the question structure into the result structure.
Solved using:Excel (HSTACK, LET, ROWS), Google Sheets, Power Query (List.Skip, List.Split, List.Transform), Python, Python in Excel, and R.
