Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
TAKE
Returns a specified number of rows or columns from an array in Excel.
Multiply Fibonacci and Lucas Numbers
Challenge No. 376: Lucas Numbers – A term is sum of immediate previous two terms.
Solved using: Python.
List Cyclops Palindromic Numbers
Challenge No. 370: A Cyclops number is a number that has a zero in the center (so, it needs to have odd number of digits).
Solved using: Python.
Perform Faro Shuffle Types
Challenge No. 369: Faro Shuffle – Divide the data in two equal parts (data will always be even, so two equal parts).
Solved using: DAX.
Sum of Unique Consecutive Numbers
Challenge No. 359: Express the numbers as sum of 2 or more unique consecutive numbers.
Solved using: R.
Exclude Weekend Vacation Dates
Challenge No. 139: Prepare the Result table.
Solved using: DAX.
Sort odd positioned numbers
Challenge No. 341: Sort the numbers at odd positions.
Solved using: Python in Excel.
Column Combining! Part 2
Challenge No. 199: Given multiple columns, concatenate them based on the order presented on the pattern column using space as a delimiter.
Solved using:Excel (BYROW, CHOOSECOLS, DROP), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, and R.
Find the first 50 Iccanobif numbers
Challenge No. 329: Find the first 50 Iccanobif numbers.
Solved using: Python.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.