Challenge No. 119: Divide the data into groups sequentially such that sum of Sale in a group should not exceed 20 and should be as close to 20 as possible in a group.
Solved using: 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.
Combining Tables
Challenge No. 54: Combine the tables
Repeat Items after every adjustment
Dynamic repeat of items for Every adjustment
Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
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.
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.
Index by Department or Mail
Challenge No. 118: Assign Index starting with 1.
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.
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.
Divide Payment Across Quarters
Challenge No. 117: Equally divide the payment over current quarter and next 3 quarters.
Solved using: Python in Excel.