Challenge No. 282: An anagram is a word which is made by arranging the letters of another word.
Solved using: Python in Excel.
Custom Grouping
Challenges related to custom data grouping.
Custom Grouping! Part 14
Challenge No. 168: The stock prices for the given dates are provided in the question table.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Table.AddIndexColumn, Table.ExpandTableColumn), Python, Python in Excel, and R.
Process Time Running Totals
Challenge No. 98: 1.
Solved using: Python.
Custom Grouping! Part 13
Challenge No. 165: Based on monthly transactions, categorize each customer for each month into one of the following groups:
New: A customer who has never made a purchase in previous months.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group, List.Difference, List.Distinct), Python, and R.
Custom Grouping! Part 12
Challenge No. 163: Convert the monthly sales data from the Question table into seasonal sales as shown in the Result table.
Solved using:Excel (FILTER, GROUPBY, HSTACK), Google Sheets, Power Query (Table.Group, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Mark Repeats in Date Column
Challenge No. 91: Transpose the problem table into result table.
Solved using: Power Query (Table.AddColumn, Table.SelectRows).
Custom Grouping! Part 11
Challenge No. 161: Extract the list of dates associated with each product and display them under each other in separate columns.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Count of People by Age Group
Challenge No. 87: Generate the result table which has the count of different age groups.
Solved using: Python in Excel.
Custom Grouping! Part 10
Challenge No. 153: The table includes two columns, From and To, where each row represents a range of dates.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.
Sum Groups Separated by Blanks
Challenge No. 75: Groups are separated by blank rows in Problem table.
Solved using: Python in Excel.