See reply to your post on 12/10/2005.

Biff

"carl" wrote in message
...
I have my transactions recorded as a buy and sell. An example is below. I
am
trying to find a formula for ColE (TimeDiff Contra) that will look at the
values in ColC,D,E then find the matching (other side of the transaction)
and
display yhe TimeDiff from that side of the transaction.

TimeDiff Side Stock Price Size TimeDiff Contra
0:00:00 Sell OMC 6.2 10 0:01:59
0:01:59 Buy OMC 6.2 10 0:00:00

Is this possible ?

Thank you in advance.