Re: comparing two values in a column and then do arithmetic

2007-07-22 Thread Rob Dixon
venkateshwar wrote: I have a large set of values like this in two different columns,both the values are variables.. I need to check if first value(ValA) is same in any of the consecutive values and then find the difference between valB of those two matched valA! and the next instant the differe

Re: comparing two values in a column and then do arithmetic

2007-07-22 Thread Jeff Pang
--- venkateshwar <[EMAIL PROTECTED]> wrote: > Hi, > > I have a large set of values like this in two > different columns,both > the values are variables.. > > > I need to check if first value(ValA) is same in any > of the > consecutive > values and then find the difference between valB of > tho

comparing two values in a column and then do arithmetic

2007-07-22 Thread venkateshwar
Hi, I have a large set of values like this in two different columns,both the values are variables.. I need to check if first value(ValA) is same in any of the consecutive values and then find the difference between valB of those two matched valA! and the next instant the difference should be bet