Challenge No. 644: List All names and total cost against each name.
Solved using: R.
DROP
Removes a specified number of rows or columns from an array in Excel.
List Alphabet And Numbers
Challenge No. 642: List all consecutive alphabets in Data column separated by comma.
Solved using: Excel VBA.
Wrap Rows By Number Gaps
Challenge No. 641: Extend the given numbers into row and wrap the row where absolute gap between two subsequent numbers is greater than 2.
Solved using: R.
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.
List Words with Three Vowels
Challenge No. 622: Generate the list of words which contain at least 3 different vowels.
Solved using: R.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
Top 3 Salespersons per Quarter
Challenge No. 619: List the top 3 salespersons for every quarter on the basis of total sales in that quarter.
Solved using: Python.
Count Consecutive Number Repeats
Challenge No. 614: Today’s challenge is contributed by Mehmet Çiçek.
Solved using: R.