Challenge No. 193: Separate sales into weekday sales (Mon-Fri) and weekend sales (Sat-Sun).
Solved using:Excel (DAY, FILTER, GROUPBY), Google Sheets, Power Query (Table.Group, Date.DayOfWeek, Table.AddColumn), Python, Python in Excel, and R.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Find missing terms in arithmetic progressions
Challenge No. 325: Find the missing terms in Arithmetic Progressions given.
Solved using: Python in Excel.
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.
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.
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.
Group Data Within Sale Limit
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.
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.
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.