Challenge No. 216: Transpose the table as shown.
Solved using: Excel VBA.
VSTACK
Stacks arrays vertically into a single column in Excel.
Outstanding Loan Day Count
Challenge No. 215: Assuming today’s date is 7-Sep-24, pivot the table as shown for Outstanding loans.
Solved using: Python in Excel.
Sort Zoo Records Alphabetically
Challenge No. 214: Align the data as per Zoo and sort them alphabetically.
Solved using: DAX.
Matrix Merge With Totals
Challenge No. 213: Merge the 2 tables and pivot them on Item with Total Row and Total Column.
Solved using: Python in Excel.
Max Frequency Characters
Challenge No. 487: Find the characters whose frequency is the maximum and also find the maximum frequency.
Solved using: Excel VBA.
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.
Generate 20×20 Number Matrix
Challenge No. 483: Generate a 20×20 matrix as given through a formula.
Solved using: Python in Excel.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Leave Group From To
Challenge No. 210: Populate the From and To Date based on type of leaves for a person.
Solved using: Python.
Add Task Duration to Start
Challenge No. 209: Populate the End dates against all owners in a pivot format as shown.
Solved using: Python.