Challenge No. 243: Polybius Cipher Decrypter –
Decrypt the text in column I as per grid in A2:G8.
Solved using: Excel VBA.
LAMBDA
Creates custom reusable functions in Excel.
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.
Prime Difference Category
Challenge No. 242: If Number1 and Number2 are primes and if difference between them is:
2 – Twin Prime
4 – Cousin Prime
6 – Sixy Prime
Categorize the Numbers given in column A and B.
Solved using: Power Query (List.Transform).
Alternate Letter Casing
Challenge No. 241: Convert the English letters into small and capital alternately.
Solved using: Excel VBA.
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.
Sorted Vowel Substitution
Challenge No. 239: Replace the vowels with vowels in sorted order.
Solved using: Excel VBA.
Filter Dates!
Challenge No. 148: For each customer, filter their first, last, and middle transactions from the provided “transactions” table.
Solved using:Excel (CHOOSEROWS, DROP, FILTER), Google Sheets, Power Query (Table.Combine, Table.Group), Python, Python in Excel, and R.
Count Stepping Numbers
Challenge No. 238: Stepping Number is that number where adjacent digits have the difference of 1 or -1.
Solved using: Python in Excel.
Unique Names with Sequence
Challenge No. 237: Prepare the result table from Problem table.
Solved using: Power Query.