Challenge No. 233: List all valid names from A2:A11
The criteria for valid names are –
1.
Solved using: Power Query.
By Difficulty
Challenges categorized by difficulty level.
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.
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.
Decode Numbered Character Words
Challenge No. 227: In column A, characters are separated by 1.
Solved using: Power Query.
Transpose Departments into Row
Challenge No. 72: Transpose the data in a single row for all departments.
Solved using: Power Query (List.Transform).
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.
Sort Numbers Leave Text
Challenge No. 226: Sort the numbers in given strings and leave the non numbers as they are.
Solved using: Power Query.