Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Calculate Finish Stock and Starting
Challenge No. 250: Calculate Finish Stock and Starting Stock.
Solved using: Python.
Tap Code Cipher Generator
Challenge No. 548: Since long, I didn’t post a cipher challenge.
Solved using: Python in Excel.
Transpose problem table into result
Challenge No. 249: Transpose problem table into result table.
Solved using: Python.
Triangular Pair Sums and Differences
Challenge No. 547: We had some challenges on Triangular numbers.
Solved using: Python.
Odd Numbers in Matrix
Challenge No. 546: List the odd numbers reading rows from left to right and columns from top to bottom.
Solved using: Python.
Transpose the problem table into
Challenge No. 248: Transpose the problem table into result table.
Solved using: Python.
Rank Players by Uppercase
Challenge No. 545: There are 6 players (q, w, e, r, t, y) and if a player wins, it appears in upper case and if it loses, then it appears in lower case.
Solved using: Python.
Prepare the result table on
Challenge No. 247: Prepare the result table on the basis of problem tables 1 & 2.
Solved using: Python.
First and Last Number Sum
Challenge No. 544: Extract the first and last set of numbers appearing in A2:A10 and sum them.
Solved using: R.