Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.
LET
Assigns names to values or calculations to simplify formulas in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
List all Palindromic phrases
Challenge No. 307: List all Palindromic phrases.
Solved using: Python in Excel.
Match Dates!
Challenge No. 183: In the question table, the dates are provided in various formats.
Solved using:Excel (IFERROR, INDEX, LAMBDA), Google Sheets, Power Query (Text.Split, Table.Distinct, Table.TransformColumns), Python, Python in Excel, and R.
Print Sine Wave for Amplitudes
Challenge No. 305: Print Sine Wave for Amplitudes given in B2
Example for Amplitudes 2, 3 and 4 are given.
Solved using: Python in Excel.
Add Index Column! Part 6
Challenge No. 182: In the question table, assign an index to the blank cells, starting from 1.
Solved using:Excel (IF, LAMBDA, LET), Google Sheets, Power Query (List.Combine, List.Split, List.Transform), Python, Python in Excel, and R.
Rank Teams by Total Points
Challenge No. 304: Wins (W), Drawn (D) and Lost (L) have weightages of 1, 0 & -1.
Solved using: Python in Excel.
Generate Output Table from Data
Challenge No. 113: Generate result table from problem table.
Solved using: Python in Excel.
Prime After Digit Removal
Challenge No. 303: Remove the digits in each position and list those numbers which are prime for all occurrences of removal.
Solved using: Python in Excel.
Table Transformation! Part 22
Challenge No. 181: Transform the question structure into the result structure.
Solved using:Excel (DROP, FILTER, HSTACK), Google Sheets, Power Query (List.Alternate, List.Transform, Table.Group), Python in Excel, and R.