Challenge No. 214: Co-prime numbers are those numbers whose Highest Common Factor (Highest Common Divisor) is 1.
Solved using: Power Query (List.Transform).
Count Matching Rows and Columns
Challenge No. 213: In the given grids, see if any column matches to a row.
Solved using: Power Query.
List Unique Assignee Priorities
Challenge No. 65: Generate the result table from problem table where Assignee and Priority are one below the other.
Solved using: Power Query (Table.Distinct, Table.Sort).
Case-Sensitive Baconian Cipher
Challenge No. 212: (Baconian Cipher – This problem is case sensitive)
A/a is 0, B/b is 1, C/c is 2.
Solved using: Power Query.
Custom Grouping! Part 8
Challenge No. 139: The stock prices for the given dates are provided in the table.
Solved using:Excel (VSTACK), Google Sheets, Power Query (Table.Group, List.Combine, List.Transform), Python, and Python in Excel.
Detect Ascending or Descending
Challenge No. 211: Find whether the numbers given in column A are in Ascending order or Descending Order.
Solved using: Power Query.
Triangle of Odd Numbers
Challenge No. 210: Generate the triangle of odd numbers as given as per number of rows given in cell B2.
Solved using: Power Query.
Sum Bird Quantity Alphabetically
Challenge No. 64: Looks like yesterday’s problem was a difficult one as only one person responded.
Solved using: Power Query (Table.Group, Table.Sort).
Number Each Character
Challenge No. 209: Insert 1., 2.
Solved using: Power Query (List.Transform).
Periodic Sales Summary!
Challenge No. 138: Based on the “transactions” table, summarize the sales for each month by breaking them into three periods:
P1: First 10 days of the month
P2: From the 11th to the 20th
P3: From the 21st onward.
Solved using:Excel (DAY, DROP, HSTACK), Google Sheets, Power Query (Date.Month, List.Distinct, Table.AddColumn), Python, Python in Excel, and R.