Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • 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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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