compare two columns and write out the delta

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

stacy - 29 Jan 2007 03:42 GMT

How can I use 1 col (col 1) of numbers as master, compare another column
(col 2) to it, then write out everything in col 1, but not in col 3 to
another col?

Thanks
Stacy Whetzell

Reply to this Message

News - 29 Jan 2007 05:05 GMT

You might need a bit more explanation here maybe an example
I am very confused

Signature

Dan Field
(Surveyor)

> How can I use 1 col (col 1) of numbers as master, compare another column
> (col 2) to it, then write out everything in col 1, but not in col 3 to
> another col?
>
> Thanks
> Stacy Whetzell

Reply to this Message

AltNrg4U - 29 Jan 2007 08:49 GMT

Stacy,
I am a little confused by your message, but if all you are looking for is a
difference between two columns, then you would have a formula in the column
that you desire.

=a1-a2

If this isn't what you are looking for, then maybe you could describe your
issue in more detail.

AltNrg4U

Reply to this Message