Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

if formula to copy down values. .based on column b into column a

Hi Experts excel 2007

Need a formula to copy the values down in column a based on column b...so

column A.            Column B
abc.                         Abc
abc.                        Blank
abc.                        Blank
cde.                       Cde
Cde.                        Blank
cde.                       Cde
0
route217
Asked:
route217
  • 2
1 Solution
 
mvidasCommented:
=IF(B2="",A1,B2)

Matt
0
 
route217Author Commented:
Thanks matt for the feedback.
0
 
mvidasCommented:
I thought I had put a line explaining what to do. Put my above formula into A2, and carry down. When there is a value in B, it takes that value, otherwise it copies whatever is above it. After copying down, copy and paste the values on top of the formula for the column A value to stay.
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now