G
Guest
I have a spread sheet a few thousand lines of "buys" and another of "sells"
I need to be able to find trades were 4 fields are the same. The way i
currently do it is excel, compbine the 2 lists, and use a formula such as
=if(A2=A1,"Y","N") in a column all the way down. Im not sure how to reference
cells above a cell in the same filed in access.
Ex.
BUY SELL
PORTFOLIO TICKER PORTFOLIO
TICKER
11111 ABC 22222
XYZ
33333 DEF 33333
DEF
44444 GHI 55555
JKL
QUERY RESULTS
PORTFOLIO TICKER
33333 DEF
I need to be able to find trades were 4 fields are the same. The way i
currently do it is excel, compbine the 2 lists, and use a formula such as
=if(A2=A1,"Y","N") in a column all the way down. Im not sure how to reference
cells above a cell in the same filed in access.
Ex.
BUY SELL
PORTFOLIO TICKER PORTFOLIO
TICKER
11111 ABC 22222
XYZ
33333 DEF 33333
DEF
44444 GHI 55555
JKL
QUERY RESULTS
PORTFOLIO TICKER
33333 DEF