Challenge No. 492: DATE CIPHER DECRYPTER – Decrypt the given messages which were encrypted using following logic.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas 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.
Sort Zoo Records Alphabetically
Challenge No. 214: Align the data as per Zoo and sort them alphabetically.
Solved using: DAX.
Sequential Number Labeling
Challenge No. 490: Fill down the numbers with following logic.
Solved using: Python in Excel.
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.
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.
Convert List to Integer Intervals
Challenge No. 486: Generate the integer intervals corresponding to given numbers.
Solved using: Python in Excel.
Group by Income Then Sort
Challenge No. 211: Append the groups one below the other and sort on Income descending, Name ascending within each group.
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.