Challenge No. 116: Prepare the forecast from Jul onwards.
Solved using: Python in Excel.
LAMBDA
Creates custom reusable functions in Excel.
Convert ISBN10 to ISBN13 Numbers
Challenge No. 309: Convert ISBN10 to ISBN13 Numbers
1.
Solved using: Python in Excel.
List Portmanteau words
Challenge No. 308: List Portmanteau words.
Solved using: Python in Excel.
Return Above Cell for Numbers
Challenge No. 115: If you encounter a number anywhere in a row, output the cell above that number along with the number.
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.
Categorize Time Intervals Status
Challenge No. 114: Count Early, On Time, Late and Out of Limit for T2 against T1.
Solved using: DAX.
List all Semi Prime Numbers
Challenge No. 306: List all Semi Prime Numbers.
Solved using: Python in Excel.
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.