Hello everyone, my problem is a very simple one.. probably easy for al
you programmers

I have a similar table in a spreadsheet like so:
Ordered........Shipped
50......................30
20......................20
10.......................5
20......................10

How would I take the difference of the two columns and have the valu
put in the first column, then have the value in the 'Shipped' colum
deleted. If the two values are identical to begin with, they would bot
be deleted.

For example in the first two rows:

Ordered........Shipped
50......................30
20......................20

Becomes...

Ordered........Shipped
20......................
......................

Thanks for any contributions!

--
grahamhurlbur
-----------------------------------------------------------------------
grahamhurlburt's Profile: http://www.excelforum.com/member.php...fo&userid=2987
View this thread: http://www.excelforum.com/showthread.php?threadid=49582