Can you sort the sheet so that the buy and sell rows are
next to each other ? Then in an additional column use a
formula to compare - if bus/sell column ='sell' then are
the values in the preceeding row equal to this row and
a 'buy' value.
With an if stament you could give a result of 1 ir true or
0 if false and then sum the column to show the number of
matches - or just look for a 1 in the new column.

-----Original Message-----

I have a s/sheet containing multiple columns. However,
one of these
columns contains only two criteria; 'buy' and 'sell'.
Another column
contains a ref. no..
What I need to do is look up each row and, for each ref.
no., if the
value in the buy/sell column is 'buy' then I need to see
if there is a
similar entry in another row, ensuring that three other
column values
(including the ref. no. column) also match, with a 'sell'
value?
Hope this makes sense?

I've been looking at the index and match functions and
feel that these
will probably be able to do what I need but unfortunately
my limited
experience prevents me from going any further.

Therefore, any help is very much appreciated.

Regards,

Adrian


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/

.