Challenge No. 129: The stock prices for the given dates are provided in the table.
Solved using:Excel (DROP, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python in Excel, and R.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Convert Dates to US Format
Challenge No. 181: Convert DMY text dates to MM/DD/YYYY format.
Solved using: Power Query.
Remove Consecutive Duplicates
Challenge No. 179: If a character appears consecutively, then remove all consecutive characters other than first.
Solved using: Excel VBA.
Name Team Statement
Challenge No. 176: If a single name => name followed by “is in team”.
Solved using: Power Query.
Add Index Column! Part 4
Challenge No. 127: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Distribute Amount Monthly
Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).
Fill Missing Store Dates
Challenge No. 50: If there is a discontinuity in dates for a Store, fill in the missing dates with details of previous records and also fill in the sequence of record numbers for a customer in that store.
Solved using: SQL.
Substring Repeat Detection
Challenge No. 171: A string can be made by repetitions of substrings.
Solved using: Excel VBA.
Sort Cities by Populated
Challenge No. 169: Order the cities columns on the basis of number of cells populated in descending order.
Solved using: Python.
Determine Cumulative Sum Based on Rules
Challenge No. 49: Generate the output table shown.
Solved using: SQL.