Challenge No. 221: Count the number of 1s if they are consecutive.
Solved using: Power Query.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Count Head Streaks by Alpha
Challenge No. 70: List those alphas which have consecutive streaks of H (H – Head, T – Tail)
List the count of consecutive occurrences in their respective columns sorted.
Solved using: Power Query.
Table Transformation! Part 15
Challenge No. 142: The Question table contains information about the fingerprinting times for various personnel when entering the company.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Table.AddColumn, Table.Group, Table.Pivot), Python, Python in Excel, and R.
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.
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.
Periodic Sales Summary!
Challenge No. 138: Based on the “transactions” table, summarize the sales for each month by breaking them into three periods:
P1: First 10 days of the month
P2: From the 11th to the 20th
P3: From the 21st onward.
Solved using:Excel (DAY, DROP, HSTACK), Google Sheets, Power Query (Date.Month, List.Distinct, Table.AddColumn), Python, Python in Excel, and R.
Pay All Quarters Customers
Challenge No. 208: Find those customers who have made at least one payment in all quarters in its range.
Solved using: Power Query.