Challenge No. 693: Generate a sequence taking first 4 numbers as 1, 2, 3, 4.
Solved using: Python.
ROW
Returns the row number of a reference 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.
Word Pairs With All Vowels
Challenge No. 671: Find the pair of words which together contain all 5 vowels.
Solved using: Python in Excel.
Transpose Table With Profit
Challenge No. 670: Transpose the table as shown.
Solved using: Python.
Fill Missing With Average
Challenge No. 666: Fill in the blanks with (Total – Sum of non Blanks Values)/Number of Blanks
Hence for row 3: (580-(170+150))/1 = 260
For row 7: (440-90)/2 = 175
For row 9: (360-0)/3 = 120.
Solved using: Python.
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.
Count Consecutive Number Repeats
Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
Find Maximum N-Digit Grid Number
Challenge No. 611: Find the N digit maximum number in given 6×6 grid either rows (left to right) or columns (top to down).
Solved using: Python.
Find Missing AP Sequence
Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.