Challenge No. 96: Calculate the Turn Around Time (TAT) i.
Solved using: Python.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Compare Rows! Part 1
Challenge No. 102: In the historical sales table, identify and extract the dates where the sales value on that date is greater than the sales on the previous date.
Solved using:Excel (DROP, FILTER, IF), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn, Table.SelectColumns), Python, Python in Excel, R, and VBA.
Extract Middle Word(s)
Challenge No. 94: Extract the middle words in given data.
Solved using: SQL.
Generate the result table as
Challenge No. 26: Generate the result table as shown.
Solved using: Power Query.
Draw Descending Triangle
Challenge No. 93: Draw the triangle as per number given in A1.
Solved using: Python.
Avg Cost Between City Pairs
Challenge No. 92: Find the average cost between the pair of cities.
Solved using: Python in Excel.
Get 4th Breakdown if >
Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
Analyse Data Using Financial Year
Challenge No. 20: Analyse the sales data by Financial Year and Financial Quaters
Assume the Financial year starts in April
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python in Excel.
Duplicate Values! Part 1
Challenge No. 100: Consider the IDs in the question table.
Solved using:Excel (CHAR, COUNTIF, COUNTIFS), Google Sheets, Power Query (List.Transform, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Pascal Case to Snake Case
Challenge No. 84: Change Pascal Case to Snake Case.
Solved using: Python in Excel.