Assigns names to values or calculations to simplify formulas in Excel.
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.
Challenge No. 223: Sort the rows in columns A through H as per Sort key.
Solved using: Power Query.
Challenge No. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.
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.
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
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.
Challenge No. 220: First row is column headers and first column is row headers.
Solved using: Power Query (List.Transform).
Challenge No. 219: Count the number of 7s for the given numbers starting from 1.
Solved using: Excel VBA.
Challenge No. 68: Populate the total sales for the companies and no.
Solved using: Excel VBA.
Challenge No. 218: Calculate Numerological Sum for a Name.
Solved using: Python in Excel.
