Formula assistance

All,

Want in collum A to apply a formula where in all blanks in that collumn it populates the part in the cell above it before the next part comes up, than the blanks under that next part to put that part, etc..., etc...

Is there one formula I can use and than filter by blanks, select visible cells, apply and wa la it does this for me?

Thanks
Sample.xlsx
Pete EdwardsAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Select your range in column A and then hold the CTRL key and select A1.

Then go to Edit|Go To and click Special....select Blanks and click Ok.

enter an = sign and hit the up arrow key.

Hold the CTRL key again and hit ENTER.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.