Challenge No. 381: IPv6 address is represented as x:x:x:x:x:x:x:x (total 8 x) where x consists of 1 to 4 Hexadecimal digits.
Solved using: Python in Excel.
⭐️⭐️⭐️⭐️ Advanced
Complex challenges for experienced users.
Fill Missing Time Fields
Challenge No. 150: You need to fill in the blanks.
Solved using: Python.
Monthly Per Diem Calculation
Challenge No. 149: The data is for business trip start and end dates of employees.
Solved using: Python.
Boundary Rows per Threshold
Challenge No. 146: For a group –
List the last row where value < Threshold
and also list the first row where value > Threshold
If more than one row meets the criterion, then capture all those rows.
Solved using: Python in Excel.
12-Month Cumulative Sales
Challenge No. 145: For every store, find the cumulative sale for 12 months periods.
Solved using: R.
Reverse Only English Alphabets
Challenge No. 360: Reverse the English alphabets in the strings.
Solved using: R.
Exclude Weekend Vacation Dates
Challenge No. 139: Prepare the Result table.
Solved using: DAX.
Create a Christmas Tree Shape
Challenge No. 354: Merry Christmas to all the readers!!! Today’s challenge, undoubtedly, will be on Christmas.
Solved using: Power Query.
List Interprime Numbers
Challenge No. 352: List the Interprime Numbers.
Solved using: Python in Excel.
Find nearest Palindrome numbers
Challenge No. 343: Palindrome number is that which is same even when read backwards.
Solved using: R.