Applies a function to each element of one or more arrays 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. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.
Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
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. 218: Calculate Numerological Sum for a Name.
Solved using: Python in Excel.
Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
Challenge No. 216: List the Vice Presidents who have been presidents also and list their vice-presidency and presidency years separated by comma.
Solved using: Power Query.
Challenge No. 215: This problem is contributed by Mehmet Çiçek.
Solved using: Python in Excel.
Challenge No. 140: For each customer, extract the ten consecutive days with the highest purchases.
Solved using:Excel (FILTER, HSTACK, IFS), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python in Excel, and R.
