Challenge No. 44: Generate result table as shown.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Extract Running Total By Group
Challenge No. 43: Generate result table as shown.
Solved using: Excel VBA.
Custom Grouping! Part 4
Challenge No. 119: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.
Grouping Data
Challenge No. 38: Sort Cookies into 2 groups: with Duplicate Price & with Unique prices Dynamic array function allowed but
Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
Dso!
Challenge No. 118: Using the sales transactions from the provided table and the account balance as of 31/08/2024, calculate the Daily Sales Outstanding (DSO) for each customer.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Return Repeat Customers
Challenge No. 37: Return only dates with repeat customers and repeated customers Dynamic array function allowed but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Add Index Column! Part 3
Challenge No. 117: Add an Index column for the Question table with a separate counter for each stock.
Solved using:Excel (COUNTIF, HSTACK, IF), Google Sheets, Power Query (Table.AddIndexColumn, Table.Group, Table.Sort), Python, Python in Excel, and R.
Add Index Column! Part 2
Challenge No. 116: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (CHOOSECOLS, CHOOSEROWS, COLUMN), Google Sheets, Power Query (List.Alternate, Table.AlternateRows, Table.Column), Python, Python in Excel, and R.
Next Palindrome Number
Challenge No. 141: Palindrome number is that which is same even when read backwards.
Solved using: Python in Excel.
Mask Specific Whole Words
Challenge No. 136: Mask the string with asterisks if a word given in Words column appears in that row.
Solved using: Power Query.