This video demonstrates how to fill down blank cells until the next value using formula, power query and VBA macro methods.
So which method to use? Well, It's all about choices.
The formula method is traditionally a popular choice among many excel users.
Power Query gives excel user that hate formula another choice.
VBA code gives excel user that love coding to fill down the blank cells more efficiently.
No comments:
Post a Comment