Challenge No. 646: Insert Quarterly total line after Mar, Jun, Jul and Dec.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
Align WBS Hierarchy Data
Challenge No. 645: Today’s challenge is contributed by Ahmad Syawal Ramli.
Solved using: Python.
Names With Total Costs
Challenge No. 644: List All names and total cost against each name.
Solved using: R.
List Alphabet And Numbers
Challenge No. 642: List all consecutive alphabets in Data column separated by comma.
Solved using: Excel VBA.
Sum Between Plus Groups
Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
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.