Challenge No. 226: Sort the numbers in given strings and leave the non numbers as they are.
Solved using: Power Query.
Find Kangaroo and Joey Words
Challenge No. 225: Kangaroo words are those words which contain the other words within themselves.
Solved using: Excel VBA.
Cap and Carry Running Totals
Challenge No. 71: Find the running total for the groups.
Solved using: Python in Excel.
Even Result by Position Sum
Challenge No. 224: List the numbers where following result is an even number
Result = Sum of Digits at Odd positions – Sum of Digits at Even positions
Positions start at 1 not at 0.
Solved using: Python in Excel.
Custom Grouping! Part 9
Challenge No. 143: Groups the sales values every week starting from Friday days starting from 1/1/2024.
Solved using:Excel (GROUPBY, LAMBDA, LET), Google Sheets, Power Query (Table.Group, Date.WeekOfYear, Table.AddColumn), Python, Python in Excel, and R.
Sort Rows by Key Count
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
List Left Truncatable Primes
Challenge No. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.
Count Head Streaks by Alpha
Challenge No. 70: List those alphas which have consecutive streaks of H (H – Head, T – Tail)
List the count of consecutive occurrences in their respective columns sorted.
Solved using: Power Query.
Count Consecutive 1s Only
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
Table Transformation! Part 15
Challenge No. 142: The Question table contains information about the fingerprinting times for various personnel when entering the company.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.AddColumn, Table.Group, Table.Pivot), Python, Python in Excel, and R.