Returns unique values from a range or array in Excel.
Challenge No. 143: Groups the sales values every week starting from Friday days starting from 1/1/2024.
Solved using:Excel (GROUPBY, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.WeekOfYear, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Challenge No. 216: List the Vice Presidents who have been presidents also and list their vice-presidency and presidency years separated by comma.
Solved using: Power Query.
Challenge No. 140: For each customer, extract the ten consecutive days with the highest purchases.
Solved using:Excel (FILTER, HSTACK, IFS), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python in Excel, and R.
Challenge No. 65: Generate the result table from problem table where Assignee and Priority are one below the other.
Solved using: Power Query (Table.Distinct, Table.Sort).
Challenge No. 64: Looks like yesterday’s problem was a difficult one as only one person responded.
Solved using: Power Query (Table.Group, Table.Sort).
Challenge No. 138: Based on the “transactions” table, summarize the sales for each month by breaking them into three periods:
P1: First 10 days of the month
P2: From the 11th to the 20th
P3: From the 21st onward.
Solved using:Excel (DAY, DROP, HSTACK), Google Sheets, Power Query (Date.Month, List.Distinct, Table.AddColumn), Python, Python in Excel, and R.
Challenge No. 61: Generate Result table on the basis of T1 and T2.
Solved using: Power Query (List.Distinct, Table.Group, Table.Pivot).
Challenge No. 201: Find the next number which is having all digits distinct.
Solved using: Python in Excel.
Challenge No. 59: Generate the result table where –
Questions should be listed in headers.
Solved using: Power Query (List.Transform, Table.SelectRows).
