Challenge No. 222: List all Left Truncatable Primes.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
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.
Apply ATBASH Cipher Rules
Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
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.
Case-Sensitive Baconian Cipher
Challenge No. 212: (Baconian Cipher – This problem is case sensitive)
A/a is 0, B/b is 1, C/c is 2.
Solved using: Power Query.
Triangle of Odd Numbers
Challenge No. 210: Generate the triangle of odd numbers as given as per number of rows given in cell B2.
Solved using: Power Query.