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.
Monthly Sales and Workdays Summary
Challenge No. 68: Populate the total sales for the companies and no.
Solved using: Excel VBA.
Calculate Name Numerology
Challenge No. 218: Calculate Numerological Sum for a Name.
Solved using: Python in Excel.
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.
Apply ATBASH Cipher Rules
Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
Vice Presidents Turned Presidents
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.
Sort Results by House and Name
Challenge No. 67: Generate result table and sort on House & Name.
Solved using: Power Query (Table.AddColumn).
Date Range Spend Total
Challenge No. 215: This problem is contributed by Mehmet Çiçek.
Solved using: Python in Excel.
Golden Period!
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.