Need help tedious work...

  • Thread starter Thread starter Soth
  • Start date Start date
S

Soth

Hi-

A B C
Total $10
Total $10
Total 20
Total 20
Total $30
Total $40

I'm doing the tedious work by cut and paste the amounts from column C to
Column B. I have thousands of lines. Is there a quickest way to achive this?

My results:
A B C
Total $10
Total $10
Total $20
Total $20
Total $30
Total $40

Thanks
 
There's actually a few ways to achieve this. So the easiest, assuming that
each row will only have a value in either column B or C, then simply use a
sum function in column D. If some rows have values in both column B and C,
then you may need to use an if statement in column D.
 
Select column B

F5>Special>Blanks>OK

Edit>Delete>Shift cells left.


Gord Dibben MS Excel MVP
 
Nuzza, yes some rows have values in both column B and C, and how do I write
if statement?

Thanks
 
Hi,

Select column B and press Ctrl+G > Special > Blanks > OK. This will select
all the blank cells. Now press the right arrow key and press Ctrl+Enter

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top