Challenge No. 378: Split the numbers into two parts where sum of first part is > sum of second part where it happens for the first time.
Solved using: R.
By Topic
Challenges categorized by topic.
Encrypt Text with Keyword Cipher
Challenge No. 377: Encrypt the gives words using Keyword Cipher.
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.
Filter Products by Date Range
Challenge No. 371: This problem is contributed by Mehmet Çiçek
Find the list of products (alphabetically sorted) for the date range given in columns H & I from the table given in columns A to F.
Solved using: DAX.
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.
Find Word by Exact Index
Challenge No. 367: Capture the word starting at given index.
Solved using: Python.
12-Month Cumulative Sales
Challenge No. 145: For every store, find the cumulative sale for 12 months periods.
Solved using: R.
Split Group and Track Running
Challenge No. 144: Divide the data set for a group in 2 halves.
Solved using: Python in Excel.
First and Last Duplicates
Challenge No. 143: List those rows for employees where first and last duplicate values occur for a value.
Solved using: Python in Excel.
End of Day Stock Record
Challenge No. 140: Work out the End of Day Stock.
Solved using: R.