Challenge No. 184: List the years in this century which are having at least 2 months which had 5 Fridays, 5 Saturdays and 5 Sundays.
Solved using: Python in Excel.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
List Buy and Sell Balances
Challenge No. 54: From the transaction table, generate output as shown.
Solved using: Power Query.
List Tetradic Numbers
Challenge No. 183: List Tetradic numbers from column A.
Solved using: Python in Excel.
Remove Consecutive Duplicates
Challenge No. 179: If a character appears consecutively, then remove all consecutive characters other than first.
Solved using: Excel VBA.
Cartesian Product!
Challenge No. 128: Write all the 3 character words by using “A”,”B”,C”, AND “D”.
Solved using:Excel (LAMBDA, LET, REDUCE), Google Sheets, Power Query (List.Transform, List.TransformMany), Python, Python in Excel, and R.
Route Cipher Encrypt
Challenge No. 178: Route Cipher
Encrypt the given Strings.
Solved using: Power Query.
Generate Club Match Table
Challenge No. 52: We had done a version of this challenge earlier.
Solved using: Power Query.
Common Digits with Frequency
Challenge No. 177: Find the common digits between Number1 and Number2 if the occurrence frequency of a digit is same in both Number1 and Number2 and occurrence frequency of that digit > 1.
Solved using: Power Query (List.Transform).
Add Index Column! Part 4
Challenge No. 127: Add an index column to the question table, with a separate counter for each stock.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (Table.AddColumn, Table.AddIndexColumn), Python, Python in Excel, and R.
Distribute Amount Monthly
Challenge No. 51: Distribute the amount over month-year for every item.
Solved using: Power Query (List.Transform).