Challenge No. 701: Swap the diagonals in 10×10 grid as shown.
Solved using: Python in Excel.
ROWS
Returns the number of rows in an array or range in Excel.
Custom Sequence from Four Terms
Challenge No. 693: Generate a sequence taking first 4 numbers as 1, 2, 3, 4.
Solved using: Python.
Assign Rank1 and Rank2
Challenge No. 691: Give the rank1 and rank2 as shown.
Solved using: Python.
Sum of Values for Alphabets
Challenge No. 690: The value associated with alphabets are given in the grid next to the alphabets.
Solved using: Python in Excel.
Split And Sum Orders
Challenge No. 682: In the problem table, if there are more than one order number, then amount will be equally divided among order numbers.
Solved using: Python.
Split And Align Columns
Challenge No. 681: Split and align the data as shown.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Matrix Transformation Series
Challenge No. 661: Today’s challenge is contributed by 🇰🇷 Taeyong Shin
Converts the T1 matrix to a T2 matrix and the T2 matrix to a T3 matrix.
Solved using: Excel.
Generate Unique Day Abbreviations
Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.
Sum Numbers in Zigzag Path
Challenge No. 623: Find the sum of numbers traversing the diagonal from first column to second column to third column to second column to first column and repeating it till the end.
Solved using: R.