Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
LAMBDA
Creates custom reusable functions in Excel.
Calculate Daily Work Hours
Challenge No. 639: Find the total time in hours worked on each day.
Solved using: Python in Excel.
Generate Unique Day Abbreviations
Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.
Insert Dashes for Nonconsecutives
Challenge No. 637: Given alphanumeric strings, insert a dash if two characters are not consecutive in increasing order.
Solved using: Python in Excel.
Identify Yearly Repeat Customers
Challenge No. 636: Find the unique repeat customers in a year.
Solved using: Python.
Compare Unique Array Elements
Challenge No. 634: Starting the week on a comfortable note.
Solved using: R.
Encrypt Words with Random Characters
Challenge No. 633: Encrypt the given words with following rules
1.
Solved using: Python.
Toggle Arithmetic Operation Signs
Challenge No. 629: If a number is preceded by + or -, change + to – and – to +.
Solved using: Python.
Calculate Cheapest Bottle Combination
Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Top Three Sales by Date
Challenge No. 624: Find the top 3 highest sales made on a date and list along with Customer Name and Date.
Solved using: Python in Excel.