Challenge No. 106: Rank the countries based on Olympic medals, starting with the number of gold medals.
Solved using:Excel, Power Query, Python, and R.
⭐️⭐️ Easy
Slightly challenging problems for learners.
GADERYPOLUKI Cipher Apply
Challenge No. 109: GADERYPOLUKI Cipher
Column A needs to be changed on the basis of key given in column B.
Solved using: SQL.
Multiple Tables Lookup
Challenge No. 25: Lookup correct exchange rate & calculate Amt To.
Solved using: Power Query.
Count Palindromes in Range
Challenge No. 107: Palindrome numbers are those which are same even when read from backwards.
Solved using: Python in Excel.
Generate Fibonacci Strings
Challenge No. 104: Generate n Fibonacci strings for given first two terms.
Solved using: SQL.
Replace with Past Vowels
Challenge No. 100: The string contains only English alphabets.
Solved using: SQL.
Count Consecutive Items
Challenge No. 23: Count Quarters with 3 Consecutive L.
Solved using: Python in Excel.
Custom Average!
Challenge No. 103: Today is 20/08/2024, and we’re calculating the average delivery time per product in days.
Solved using:Excel (AVERAGE, CHOOSECOLS, FILTER), Google Sheets, Power Query (Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Find Two Numbers with Sum
Challenge No. 98: From column A, find 2 numbers which when summed give the sum as in column C.
Solved using: Python.
Count Unique Odd Digit Numbers
Challenge No. 97: Yesterday, I ended up posting a complex challenge.
Solved using: Python in Excel.