Returns a specified number of rows or columns from an array in Excel.
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.
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
Solved using: R.
Challenge No. 478: Merger the tables into a single table.
Solved using: Python.
Challenge No. 477: Align the data as shown which is 1 record, then 2 records, then 3 records and so on.
Solved using: Python in Excel.
Challenge No. 206: Generate the result table from problem table.
Solved using: Python in Excel.
Challenge No. 472: All rows carry one mathematical operator (to simplify only 4 basic maths operators which are +, -, * and / ).
Solved using: Python in Excel.
Challenge No. 64: Rank the Fruits Based on Demand
e.
Solved using: Python.
Challenge No. 200: Merge the two tables by taking maximum marks of the subject.
Solved using: Python in Excel.
Challenge No. 198: Find the running total on the basis of max value for the month.
Solved using: Python.
Challenge No. 60: Group the customers per month.
Solved using: Python.
