Challenge No. 237: Fill in the blanks / nulls with column name_1, 2, 3.
Solved using: Python.
INDEX
Returns a value or reference from a table based on row and column numbers in Excel.
Align Rowwise Data
Challenge No. 520: Align the data as given in answer expected.
Solved using: Python in Excel.
Repeat Rows Until Next Date
Challenge No. 232: Repeat a row till the next date.
Solved using: Python in Excel.
Quantity Times Price Total
Challenge No. 231: Pivot the problem tables into result table.
Solved using: Python in Excel.
Perfect Square Predecessor Checker
Challenge No. 517: Arrange the given numbers in such a fashion that sum of preceding + current number is a perfect square.
Solved using: Python in Excel.
Normalize Tabular Data
Challenge No. 515: Normalize the data given in columns A to B as given in Answer Expected.
Solved using: Python.
Max 2×2 Grid Sum
Challenge No. 514: Find the 2×2 grids in the given 5×5 grid where sum is the maximum.
Solved using: Python in Excel.
Compute Pandovan Sequence Terms
Challenge No. 485: Pandovan Sequence – In number theory, the Pandovan sequence is the sequence of integers P(n) defined[1] by the initial values
P ( 0 ) = P ( 1 ) = P ( 2 ) = 1
and the recurrence relation
P ( n ) = P ( n − 2 ) + P ( n − 3 )
Find the nth term given in column A.
Solved using: R.
Detect Wavy Number Pattern
Challenge No. 474: Wavy numbers – List the numbers where digits alternately get smaller or larger (they should not be equal).
Solved using: Excel VBA.
Evaluate Concatenated Math Rows
Challenge No. 472: All rows carry one mathematical operator (to simplify only 4 basic maths operators which are +, -, * and / ).
Solved using: Python in Excel.