Challenge No. 230: This challenge is contributed by Mehmet Çiçek.
Solved using: Excel VBA.
Length Of Pattern!
Challenge No. 145: Find the largest length of occurrences of the “++-” pattern across the test IDs for each product.
Solved using:Excel (CONCAT, GROUPBY, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Combine, Table.AddColumn), Python, Python in Excel, and R.
96 Common Challenges in Power Query
96 Common Challenges in Power QueryPractical Solutions for … 96 Common Challenges in Power QueryRead more
Find Double Base Palindromes
Challenge No. 229: Find all double base Palindrome Numbers.
Solved using: Python in Excel.
Multiply Columns by Factor Dynamically
Challenge No. 73: Multiply Alpha, Beta, Gamma columns with Factor column.
Solved using: Python in Excel.
Encrypt Using Affine Cipher
Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.
Classify Deficient Perfect Abundant
Challenge No. 228: Take a positive integer n and add its positive divisors (let’s denote it by S)
Classify the numbers as per given criteria:
If S < 2n = Deficient Number
If S = 2n = Perfect Number
If S > 2n = Abundant Number
Ex.
Solved using: Python in Excel.
Transpose Departments into Row
Challenge No. 72: Transpose the data in a single row for all departments.
Solved using: Power Query (List.Transform).
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
First Date Of Months!
Challenge No. 144: From the provided “transactions” table, filter the first transaction for each.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Date.Month, Table.AddColumn, Table.Group), Python, Python in Excel, and R.