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.
BYROW
Applies a function to each row in an array in Excel.
Custom Grouping! Part 5
Challenge No. 123: Group the sales values in 10-day intervals, starting from January 1, 2024.
Solved using:Excel (BYROW, DAY, GROUPBY), Google Sheets, Power Query (Table.Group, List.Transform, Table.Group), Python, Python in Excel, and R.
Common Digits in Row
Challenge No. 151: List the common digits between all the numbers in a row.
Solved using: Python in Excel.
Generate Concatenation Table
Challenge No. 110: Generate the result table.
Solved using: SQL.
Count Rows with All Values
Challenge No. 95: Find the number of rows in the grid B2:M10 where O2:O4 values appear at least once.
Solved using: Python.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Knn Missing Value!
Challenge No. 86: K-nearest neighbors (KNN) is a simple technique for replacing missing values with the average of the nearest values.
Solved using:Excel, Power Query, and VBA.
Find Max Points by Rounds
Challenge No. 5: Provide a formula to know the name of the persons who have the highest Points on the basis of Round1+Round2+Round3.
Solved using: Python in Excel.
Add Index Column! Part 1
Challenge No. 67: In the Question table, indexes along with their ranks in different references are provided.
Solved using:Excel (BYROW, FILTER, LAMBDA), Power Query (List.Skip, List.Transform, Table.SelectRows), Python, R, and VBA.
Match Payments!
Challenge No. 60: The customer receipt costs and their payments are provided in Question Tables 1 and 2.
Solved using:Excel, Power Query, and R.