Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
MAP
Applies a function to each element of one or more arrays 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.
Find largest sum of contiguous cells
Challenge No. 320: Work out the largest sum for contiguous cells given in the range A2:A10.
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.
Swap first and last letters unless vowels
Challenge No. 317: Swap the first and last letter of each words in given names.
Solved using: DAX.
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.
Find texts that are ATBASH Palindromes
Challenge No. 314: ATBASH Palindrome – In ATBASH cipher, we replace a with z, b with y, c with x.
Solved using: Python in Excel.
Column Splitting! Part 4
Challenge No. 186: Split the ID into two columns:
The first column should contain all vowels (A, E, I, O, U).
Solved using:Excel (BYROW, CONCAT, HSTACK), Google Sheets, Power Query (Text.Combine, Text.Remove, Text.Select), Python, Python in Excel, and R.