Challenge No. 679: For production runs, number of items (say N) to be selected in one go is given in every column.
Solved using: Python.
BYCOL
Applies a function to each column in an array in Excel.
Bottom Three Unique Values
Challenge No. 650: List the bottom 3 unique values across the columns.
Solved using: Python.
Calculate Daily Work Hours
Challenge No. 639: Find the total time in hours worked on each day.
Solved using: Python in Excel.
Generate Unique Day Abbreviations
Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.
Count Alphabetically Sorted Words
Challenge No. 601: Find the count of words in columns A through C if the words have sorted alphabets.
Solved using: Python in Excel.
Minimum Sum Unique Pairs
Challenge No. 588: Find the unique pairs for which sum in minimum across the columns.
Solved using: R.
Odd Numbers All Directions
Challenge No. 550: Last week, we had this challenge.
Solved using: Python in Excel.
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.
Calculate Monthly Payments
Challenge No. 217: Transpose the table as shown by showing the amount paid each month.
Solved using: Python in Excel.
Show Transposed Amount Values
Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
