Challenge No. 683: Find the value corresponding to numbers given in column N from the grid given of left hand side.
Solved using: Python.
LEFT
Extracts a specified number of characters from the beginning of a text string in Excel.
Insert Yearly Sum Totals
Challenge No. 660: Insert the sum for the year after the year ends.
Solved using: Python.
Generate Unique Day Abbreviations
Challenge No. 638: Given are Day of week names in 3 languages.
Solved using: Excel VBA.
Generate Sequential Ticket Numbers
Challenge No. 620: Create the ticket numbers for each State.
Solved using: Python.
Match Names with Same Initials
Challenge No. 612: List the names if first character of first name and first character of last name are same.
Solved using: Python.
Cross Product with Repeats
Challenge No. 585: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: Python.
Cross Product with Multiples
Challenge No. 584: Prepare the cross product of Column1 with Column2 where an entry should be repeated by the number in brackets.
Solved using: R.
Check Lexically Sorted Dates
Challenge No. 507: List the dates which are lexically sorted.
Solved using: Python.
Presidents with Same Initials
Challenge No. 504: List those presidents’ names whose first characters of all parts of names are same.
Solved using: Excel VBA.
List First 10 Tech Numbers
Challenge No. 494: Generate the first 10 Tech Numbers.
Solved using: R.