Friday, October 30, 2015

How to Fill Down a Column with Different Values Along the Way

So here is the scenario:

You have values in a column spaced out between empty rows.

But you want to fill down the values and when it meets another value you want it to continue to fill down with the new value.
You know that if you use Ctrl + D, it will fill down until it meets the next value and you know you can also do this by clicking the bottom right corner.

But how do you do it automatically if you had like 100s of stops?

Use the IF formula.

First create an empty top row.

Next put this formula in column B2

 =IF(A2<>"",A2,B1)



And fill down column B

Presto, you have your Dynamic Changing Fill Down.








How to Enable Developer Mode in Excel

To enable developer mode in excel you need ot go to the excel options.

File > Options > Customize Ribbon > Checkmark Developer > OK

Now your ready to start coding some vba to do some macros and automation!