merge two rows

C

CandiC

I have information in columns A and B however the price is indicated in
Column A for some rows and Column B for some and in both for others. I am
interested in keeping the actual cost when available, however, when the ACT
CST is blank I would like to populate it with the STD CST stated. I would
like to merge the two colums into one As follows:

Col A ........Col B ...........Col C............Col D
Part No......STD CST......ACT CST.......Merged
152C............2.00............Blank............2.00
153A............Blank..........7.50..............7.50
165A............9.56...........Blank.............9.56
175V............12.20.........12.35............12.35
187A............Blank..........5.23.............5.23
185A............1.25...........4.21.............4.21

Is there a formula that can do this or would this require a macro?
 
P

PSULionRP

Why don't you write an "IF" statement in the D Cells to take care of this.

Something like this...

=IF(B2<>"",D2=B2,D2=C2)
 
P

PSULionRP

Actually...my bad...

=IF(C2<>"",D2=C2,D2=B2)

I hope you get the idea. A couple of assumptions here...the columns are
formatted in such a way that <blank> is valid and they are NOT 0. And also
assuming that at least one of your columns, STD CST or ACT CST, will have a
value. Will they or could they ever both be <blank>...
 
C

CandiC

You are correct in stating that the value in columns, A, B or C will always
be <blank> and never be zero, However the values are dynamic meaning that
Col. B could be >,<,or = to column C and visa versa.
The following formula is only returning a (-) dash mark as an answer. So it
doesn't seem to work, any other ideas?
 
P

PSULionRP

Try this...

=IF(C2<>"",C2,B2)

CandiC said:
You are correct in stating that the value in columns, A, B or C will always
be <blank> and never be zero, However the values are dynamic meaning that
Col. B could be >,<,or = to column C and visa versa.
The following formula is only returning a (-) dash mark as an answer. So it
doesn't seem to work, any other ideas?
 
P

PSULionRP

Was I able to help Candi???

CandiC said:
You are correct in stating that the value in columns, A, B or C will always
be <blank> and never be zero, However the values are dynamic meaning that
Col. B could be >,<,or = to column C and visa versa.
The following formula is only returning a (-) dash mark as an answer. So it
doesn't seem to work, any other ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top