Easy challenges for newcomers.
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. 227: In column A, characters are separated by 1.
Solved using: Power Query.
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.
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.
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Challenge No. 218: Calculate Numerological Sum for a Name.
Solved using: Python in Excel.
Challenge No. 141: For each blank cell, replace the null value with the value from the row above that has the same ID.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
