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.
LET
Assigns names to values or calculations to simplify formulas in Excel.
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.
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.
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.
Number Each Character
Challenge No. 209: Insert 1., 2.
Solved using: Power Query (List.Transform).