Challenge No. 132: In Question Table 1, values are provided for each code.
Solved using:Excel (FILTER, FIND, ISNUMBER), Google Sheets, Power Query (Text.Contains, Table.AddColumn, Table.SelectRows), Python, Python in Excel, R, and VBA.
Table.SelectRows
Filters rows in a table based on a condition in Power Query.
First In First Out (Fifo)!
Challenge No. 130: Consider a warehouse operating with an initial value of 0 and following a First-In, First-Out (FIFO) approach.
Solved using:Excel (FILTER, TAKE), Google Sheets, Power Query (Table.SelectRows), Python, Python in Excel, and R.
Months With 5 Weekends
Challenge No. 184: List the years in this century which are having at least 2 months which had 5 Fridays, 5 Saturdays and 5 Sundays.
Solved using: Python in Excel.
Table Transformation! Part 11
Challenge No. 122: Transform the question table into the reult table format.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Transform, Text.Contains, Table.AddColumn), Python, 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.
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.
List All Pangram Sentences
Challenge No. 146: A Pangram (also known as Holoalphabetic) sentence is that which contains all 26 letters of English alphabets at least once.
Solved using: Power Query (Table.SelectRows).
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.
Match employee names using wildcard
Challenge No. 36: There are two tables.
Solved using: SQL.
Compare Rows! Part 2
Challenge No. 111: In the historical sales table, extract the dates where the total sales value is greater than the total on the previous date
for example, in 2/1/2024 total sales were 14 and is greater than total sales on 1/1/2024 which is 11.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.Group, Table.SelectRows), Python, Python in Excel, and R.