Excel Formula

I have an excel workbook with a few sheets. Our main focus are sheets "Step 2" and "Step 3". If you notice, the workbook is a Macro enabled workbook. The goal is to achieve the same results of the macro using a formula, instead of the macro and getting rid of the macro all together. 

Please review my video (attached) for instructions.