Challenge No. 315: Remove the English letters appearing in Planets column from Author Column.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Custom Grouping! Part 17
Challenge No. 187: Group the rows until encountering a missing date.
Solved using:Excel (DROP, GROUPBY, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
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.
Generate the result table with Tn = T(n-2) & Tn
Challenge No. 313: Generate the result table.
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.
List all Sumproduct numbers
Challenge No. 312: List all Sumproduct numbers from column A.
Solved using: Python in Excel.
Extracting Whole Route
Challenge No. 53: Generate a whole route for the airlines
e.
Solved using: R.
Sort the digits of given numbers in descending order
Challenge No. 311: Sort the digits of given numbers in column A in descending order.
Solved using: Python in Excel.
Replace Consecutive X!
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Find the next 3 Friday the 13th dates
Challenge No. 310: Find the next 3 Friday the 13th dates for dates given in column A.
Solved using: Python in Excel.