Returns a specified number of rows or columns from an array in Excel.
Challenge No. 192: Any row with a negative quantity should reduce the corresponding value in the previous rows for the related product.
Solved using:Excel (DROP, FILTER, LAMBDA), Google Sheets, Power Query (Table.Group, Table.SelectRows, Table.Sort), Python, Python in Excel, and R.
Challenge No. 322: Find the top 3 employees whose salary is nearest to average salary.
Solved using: DAX.
Challenge No. 189: Given multiple columns, concatenate them based on a predefined pattern.
Solved using:Excel (BYROW, CONCAT, IF), Google Sheets, Power Query (List.ReplaceMatchingItems, List.Transform, List.Zip), Python, Python in Excel, and R.
Challenge No. 316: A Fibonacci number is a sum of previous two terms starting with 0 & 1.
Solved using: Excel VBA.
Challenge No. 310: Find the next 3 Friday the 13th dates for dates given in column A.
Solved using: Python in Excel.
Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python in Excel.
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.
Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
Challenge No. 180: In the question table, parents and their children with different IDs are listed.
Solved using:Excel, Google Sheets, Power Query, Python in Excel, and R.
Challenge No. 297: Simplified version of Reverse Polish Notation (RPN) – The math operator will come at the end of the Text and you need to evaluate the expression.
Solved using: Python in Excel.
