Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Matching (ContraSide) Transactions
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Matching (ContraSide) Transactions
Hi!
Let's see if I understand........ If "one side" of a transaction is "sell", then the other "side" must be "buy" and vice versa. No error checking in this. This assumes that there will always be an "opposite side" for each entry. In other words, every "sell" has a corresponding "buy" and vice versa. Entered as an array using the key combo of CTRL,SHIFT,ENTER: =IF(B2="sell",INDEX(A$2:A$20,MATCH(1,(B$2:B$20="bu y")*(C$2:C$20=C2)*(D$2:D$20=D2)*(E$2:E$20=E2),0)), INDEX(A$2:A$20,MATCH(1,(B$2:B$20="sell")*(C$2:C$20 =C2)*(D$2:D$20=D2)*(E$2:E$20=E2),0))) 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Matching (ContraSide) Transactions
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count matching cells | Excel Worksheet Functions | |||
Finding One Value, Matching Three Criteria | Excel Discussion (Misc queries) | |||
finding matching cells in worksheets | Excel Worksheet Functions | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
Finding the cell reference of a matching search value | Excel Worksheet Functions |