Generates a sequence of numbers in an array in Excel.
Challenge No. 146: Split the IDs from the beginning of the text up to the “|” character in each occurrence of “|”.
Solved using:Excel (IFNA, LAMBDA, LEN), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, R, and VBA.
Challenge No. 234: Find the numbers which are divisible by their individual digits.
Solved using: Python in Excel.
Challenge No. 231: List Yes if a Number is Pandigital number in a given base else No.
Solved using: Power Query.
Challenge No. 230: This challenge is contributed by Mehmet Çiçek.
Solved using: Excel VBA.
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.
Challenge No. 229: Find all double base Palindrome Numbers.
Solved using: Python in Excel.
Challenge No. 232: Affine Cipher
This is a kind of Caesar’s Cipher.
Solved using: Excel VBA.
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.
Challenge No. 224: List the numbers where following result is an even number
Result = Sum of Digits at Odd positions – Sum of Digits at Even positions
Positions start at 1 not at 0.
Solved using: Python in Excel.
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
