Challenge No. 218: Transpose the table as shown.
Solved using: Python in Excel.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Index Range Closest to 100
Challenge No. 493: List the Start and End Indexes where sum of numbers <=100 with minimum gap between sum of numbers and 100. Solved using: R.
Date Cipher Decryption
Challenge No. 492: DATE CIPHER DECRYPTER – Decrypt the given messages which were encrypted using following logic.
Solved using: Python 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.
Sequential Number Labeling
Challenge No. 490: Fill down the numbers with following logic.
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.
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.
Score Matrix for Team Matches
Challenge No. 482: Prepare the given matrix from problem table.
Solved using: Python in Excel.
Detect Hardy-Ramanujan Numbers
Challenge No. 481: A taxicab number (also known as Hardy Ramanujan Number) is a positive integer that can be expressed as the sum of two positive cubes in more than one way.
Solved using: R.