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?
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?