Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 10th 05, 02:10 PM posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default 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   Report Post  
Old December 11th 05, 03:30 AM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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$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$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   Report Post  
Old December 12th 05, 07:57 PM posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count matching cells The Mage Excel Worksheet Functions 4 September 18th 05 03:36 AM
Finding One Value, Matching Three Criteria cattle mgr Excel Discussion (Misc queries) 2 August 29th 05 08:32 PM
finding matching cells in worksheets Marcin Wolku Excel Worksheet Functions 1 August 25th 05 04:46 PM
Finding Duplicate Names from Different Lists... PokerZan Excel Discussion (Misc queries) 1 July 8th 05 09:58 AM
Finding the cell reference of a matching search value ndrewitt Excel Worksheet Functions 0 April 13th 05 01:43 AM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017