Challenge No. 298: Work our the pair of persons for whom the sum of call duration is the highest.
Solved using: Python in Excel.
LEFT
Extracts a specified number of characters from the beginning of a text string in Excel.
List Tautonym words
Challenge No. 294: List Tautonym words.
Solved using: Python in Excel.
List all Right Truncatable Primes
Challenge No. 286: List all Right Truncatable Primes.
Solved using: Python in Excel.
Classify Sentence Text Case
Challenge No. 270: Classify the sentences as per case
All Lowercase – All letters in lowercase
All Caps – All letters in uppercase
Start Case – First letters of all words in uppercase
Sentence Case – Only first letter of first word in uppercase
Mixed Case – Not following any of the rules above.
Solved using: Python in Excel.
Column Splitting! Part 3
Challenge No. 156: If the IDs contain an even number of characters, split them into two columns at the midpoint.
Solved using:Excel (HSTACK, IF, IFNA), Google Sheets, Power Query (List.Transform, Text.End, Text.Start), Python, Python in Excel, and R.
Decrypt Polybius Cipher Grid
Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
Trim Characters Before Asterisk
Challenge No. 194: Remove the characters preceding the asterisks.
Solved using: Power Query.
Find Missing Letters in Order
Challenge No. 193: Listed are the strings where letters are in increasing order.
Solved using: Power Query.
Substring Repeat Detection
Challenge No. 171: A string can be made by repetitions of substrings.
Solved using: Excel VBA.
Top Initials of First Ladies
Challenge No. 165: List the First Ladies’ names which start with Top 3 most frequently occurring letters.
Solved using: Power Query.