Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
List subjects appearing within +/-1 row in column B
Challenge No. 324: List the subjects from column A which appear in column B within +1 or -1 position to column A.
Solved using: DAX.
Find palindromic substrings with at least 3 digits
Challenge No. 323: Find the substrings of given numbers which are Palindromic.
Solved using: DAX.
Column Splitting! Part 5
Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.
List all Powerful numbers
Challenge No. 319: List all Powerful numbers.
Solved using: DAX.
Column Combining! Part 1
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Find the Sum of the Series
Challenge No. 318: Find the Sum of the Series – 1*2*3 + 2*3*4 + 3*4*5+.
Solved using: DAX.
Matrix Calculation! Part 1
Challenge No. 188: Create a formula that, for any given value of ‘n’, generates an ‘n x n’ identity matrix where all values are 0, except for the diagonal (primary) values, which should be 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Transform), Python, and Python in Excel.
Find the first 20 EVEN Fibonacci numbers
Challenge No. 316: A Fibonacci number is a sum of previous two terms starting with 0 & 1.
Solved using: Excel VBA.
Remove letters in Planets column from Author Column
Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.