Challenge No. 69: Create Qty Group and Sum the Amount
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: R.
SEQUENCE
Generates a sequence of numbers in an array in Excel.
Fill Sequence and Compute Sum
Challenge No. 497: For given range A2:A100, populate 1, 2, 3.
Solved using: Python in Excel.
Date Cipher Decryption
Challenge No. 492: DATE CIPHER DECRYPTER – Decrypt the given messages which were encrypted using following logic.
Solved using: Python in Excel.
Repeat Pythagorean Triplet Finder
Challenge No. 491: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.
Subset Sum to Target
Challenge No. 488: This problem is contributed by Mehmet Çiçek
Find the numbers from column A which add up to the total given in column B.
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.
Find Pythagorean Triplets
Challenge No. 484: Pythagorean Triplets follow the rule a^2 + b^2 = c^2
Find a, b, c where a + b + c = Sum (which is column A).
Solved using: Python in Excel.
Generate 20×20 Number Matrix
Challenge No. 483: Generate a 20×20 matrix as given through a formula.
Solved using: Python in Excel.
Decrypt Caesar Cipher Variation
Challenge No. 480: Decrypt the given Encrypted text.
Solved using: Python in Excel.