Challenge No. 642: List all consecutive alphabets in Data column separated by comma.
Solved using: Excel VBA.
IF
Returns one value for TRUE and another for FALSE based on a condition in Excel.
Sum Between Plus Groups
Challenge No. 640: Treat the data between two pluses as one group.
Solved using: R.
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.
Calculate Cheapest Bottle Combination
Challenge No. 628: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Sum Numbers in Zigzag Path
Challenge No. 623: Find the sum of numbers traversing the diagonal from first column to second column to third column to second column to first column and repeating it till the end.
Solved using: R.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
Schedule Tasks Using Dependencies
Challenge No. 618: Today’s challenge is contributed by Abdelrahman Omer, MBA, PMP.
Solved using: Python.
Count Consecutive Number Repeats
Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.
Find Missing AP Sequence
Challenge No. 609: The first and last terms in an Arithmetic Progressions (AP) are given in each row.
Solved using: Python in Excel.
Detect Possible Date Formats
Challenge No. 605: Out of 3 date formats only, MDY, DMY & YMD, list the date formats for given dates.
Solved using: Python.