Challenge No. 106: Get the data for all shops corresponding to latest date as shown in the result table.
Solved using: Python in Excel.
Date & Time Handling
Working with date and time values.
Weekday Count of Christmas
Challenge No. 105: Find the counts of weekday names of Christmas during last n years mentioned in A1.
Solved using: SQL.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.
Get 4th Breakdown if >
Challenge No. 90: Find the 4th breakdown date of machines, only if total number of breakdowns > 4.
Solved using: Python.
Frequent Starting Team Letters
Challenge No. 76: — This week will be FIFA World Cup week.
Solved using: Power Query.
Consecutive Wins Within Span
Challenge No. 21: List the names who have won consecutively at least 3 times within a span of 180 days.
Solved using: Power Query.
Find Palindromic Dates
Challenge No. 68: List the Palindrome dates in 21st century i.
Solved using: Python in Excel.
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.
Workdays in Each Year
Challenge No. 59: In 21st century (i.e.
Solved using: Power Query.
Consecutive Dates Task Grouping
Challenge No. 17: (Excel formulas also welcome)
Generate the output table.
Solved using: Power Query.