Challenge No. 217: ATBASH Cipher
This is case sensitive problem.
Solved using: Excel VBA.
LAMBDA
Creates custom reusable functions in Excel.
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.
Find Co-Prime Pairs
Challenge No. 214: Co-prime numbers are those numbers whose Highest Common Factor (Highest Common Divisor) is 1.
Solved using: Power Query (List.Transform).
Count Matching Rows and Columns
Challenge No. 213: In the given grids, see if any column matches to a row.
Solved using: Power Query.
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.
Detect Ascending or Descending
Challenge No. 211: Find whether the numbers given in column A are in Ascending order or Descending Order.
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.