Challenge No. 340: From dataset in column A, create the table under Answer Expected.
Solved using: Python in Excel.
HSTACK
Stacks arrays horizontally into a single row in Excel.
Column Splitting! Part 6
Challenge No. 196: Split the ID into two columns:
The first column should contain all letters.
Solved using:Excel (CONCAT, HSTACK, LAMBDA), Google Sheets, Power Query (List.Transform, Text.Select, Table.AddColumn), Python, Python in Excel, and R.
Find Min and Max for all zones
Challenge No. 332: Find the Max and Min for all Zones.
Solved using: Python in Excel.
List numbers expressible as sum of two cubes
Challenge No. 331: List those numbers which can be expressed as the sum of cube of two numbers.
Solved using: Python in Excel.
Pattern Length!
Challenge No. 194: For each date, samples are evaluated based on quality and marked with a “+” sign if they are within range and a “-” sign if they are out of range.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (List.Transform, Text.Remove, Text.Split), Python, Python in Excel, and R.
Top 3 marks with names and subjects
Challenge No. 327: List the top 3 marks and names and subjects against them.
Solved using: Python in Excel.
Custom Grouping! Part 18
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.
Column Splitting! Part 5
Challenge No. 191: If an ID contains multiple separators (like -, _, .
Solved using:Excel (HSTACK, LAMBDA, LEN), Google Sheets, Power Query (Text.PositionOf, Table.AddColumn, Table.FromRows), Python, Python in Excel, and R.
Top 3 employees nearest to average salary
Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
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.