Returns one value for TRUE and another for FALSE based on a condition in Excel.
Challenge No. 185: In the ID column, Replace all instances of “X” if it appears consecutively more than once with just an “X”.
Solved using:Excel (DROP, HSTACK, IF), Google Sheets, Power Query (Text.Combine, Table.Group, Table.TransformColumns), Python, Python in Excel, and R.
Challenge No. 114: Count Early, On Time, Late and Out of Limit for T2 against T1.
Solved using: DAX.
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.
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.
Challenge No. 51: Calculate running totals for defective free units
Running Total resets to ZERO with each defection noted
For example, on the 14th, the running total is 214 since we have defects on the 13th
Dynamic array function allowed, but Extra marks for Legacy solutions or PowerQuery Solution.
Solved using: Python.
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.
Challenge No. 112: Generate the result table from problem table where Hours are summation for a particular role.
Solved using: Python in Excel.
Challenge No. 302: Generate Vigenere Cipher Grid.
Solved using: Python.
Challenge No. 300: Fill in 10×8 grid with numbers sequentially skipping X.
Solved using: Python in Excel.
Challenge No. 110: Fill in the alphabets from Names column in Name1.
Solved using: Python in Excel.
