Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
LAMBDA
Creates custom reusable functions in Excel.
List Left Truncatable Primes
Challenge No. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.
Count Consecutive 1s Only
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
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.
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.
Top Headers by Total
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Count Total 7s Appeared
Challenge No. 219: Count the number of 7s for the given numbers starting from 1.
Solved using: Excel VBA.
Calculate Name Numerology
Challenge No. 218: Calculate Numerological Sum for a Name.
Solved using: Python in Excel.
Monthly Sales and Workdays Summary
Challenge No. 68: Populate the total sales for the companies and no.
Solved using: Excel VBA.
Fill Up And Down !
Challenge No. 141: For each blank cell, replace the null value with the value from the row above that has the same ID.
Solved using:Excel (FILTER, HSTACK, IF), Google Sheets, Power Query (Table.Group), Python, Python in Excel, and R.