Challenge No. 254: List those strings which contain at least 3 asterisks between English alphabets.
Solved using: Power Query.
TEXTSPLIT
Splits a text string into an array based on delimiters in Excel.
Recover Missing Cipher Keys
Challenge No. 253: NOTE – Order in answer is not important.
Solved using: Power Query (Text.Combine).
Sort Words by End Digit
Challenge No. 246: All words have a one digit number as its last character.
Solved using: Power Query.
Identify Diamond Strings
Challenge No. 245: List all Diamond strings from column A.
Solved using: R.
Eight Queens Puzzle!
Challenge No. 150: Theeight-queenss puzzle is the problem of placing eight chess queens on an 8×8 chessboard so that no two queens threaten each other; thus, a solution requires that no two queens share the same row, column, or diagonal.
Solved using:Excel (DROP, IF, LAMBDA), Google Sheets, Power Query (List.Combine, List.Transform), and Python in Excel.
Extract From Text! Part 3
Challenge No. 149: Extract texts between and pair of the bellow characters.
Solved using:Excel (LAMBDA, LET, MAP), Google Sheets, Power Query (Table.AddColumn), Python, Python in Excel, and R.
Sum Values by Letter Codes
Challenge No. 77: Generate the result table from problem table.
Solved using: Python in Excel.
Group Text by Keyword
Challenge No. 235: Populate the Groups (from table 2) on the basis of words appearing in Text column.
Solved using: Power Query.
Column Splitting! Part 2
Challenge No. 146: Split the IDs from the beginning of the text up to the “|” character in each occurrence of “|”.
Solved using:Excel (IFNA, LAMBDA, LEN), Google Sheets, Power Query (List.Transform, Text.Combine, Text.Split), Python, Python in Excel, R, and VBA.
Validate Multi-Word Names
Challenge No. 233: List all valid names from A2:A11
The criteria for valid names are –
1.
Solved using: Power Query.