Challenge No. 166: In the provided table, the Date Time values correspond to different time zones (specified in the column GMT From).
Solved using:Excel (BYROW, HSTACK, LAMBDA), Google Sheets, Power Query (Text.End), Python, Python in Excel, and R.
Compare Store1 vs Store2 Visits
Challenge No. 96: List Customer1 whose Store1 Visit Date Time is less than or equal to Store2 Visit Date Time if they visited Store2 also.
Solved using: Power Query (Table.SelectRows).
Concatenated Multiples All Digits
Challenge No. 274: List those numbers when a number is multiplied by 2 once and 3 once and we join the original number with results of these multiplications, then the result should contain all digits from 0 through 9.
Solved using: Python in Excel.
Fix and Transpose Messy Table
Challenge No. 95: Transpose the problem table into result table.
Solved using: Power Query.
List Autobiographical Numbers
Challenge No. 273: List all numbers which are Autobiographical numbers.
Solved using: Python in Excel.
Custom Grouping! Part 13
Challenge No. 165: Based on monthly transactions, categorize each customer for each month into one of the following groups:
New: A customer who has never made a purchase in previous months.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group, List.Difference, List.Distinct), Python, and R.
Find Max Substring from Length
Challenge No. 271: Cut all substrings from column A of length given in column B and find the max.
Solved using: Python in Excel.
Extract From Text! Part 6
Challenge No. 164: In Power Query, a list is defined by { } and can contain sublists, such as {1, 2, {3, 4}}.
Solved using:Excel, Google Sheets, Power Query, Python, and R.
List Year of Maximum Values
Challenge No. 93: List the Maximum Amount and the Years in which these maximum amounts occurred.
Solved using: Python in Excel.
Classify Sentence Text Case
Challenge No. 270: Classify the sentences as per case
All Lowercase – All letters in lowercase
All Caps – All letters in uppercase
Start Case – First letters of all words in uppercase
Sentence Case – Only first letter of first word in uppercase
Mixed Case – Not following any of the rules above.
Solved using: Python in Excel.