Search results

Will do so, If anyone else has an idea I would appriciate it. Lee

Hi Ed, I am pretty sure VB is necesary. The rows have no meaning. Data on the left side is streaming, not sorted by contract, rather then by time of action. Therefor there is no reason to link right to left side by row number. On the right there is a list of available contracts, sorted by...

Cell J5 (under Cur Value)

Ok Ill give it a try =IF(AND(A5=I5,ISERR(SEARCH(C5,"T")),C5,{Don't Know}) I5 = Contract name (i.e. MAR08 -APR08) "T" in column C means there was a trade at this price, SEARCH would return an error if no "T" was found. The FALSE part of the IF should contain the original value in J5. i.e. if...

This is a Tools-Pro Excel extension of Reuters 3000 Extra. I can send you the file but without direct access to Reuters you will not see the data. Instead I am attaching a print-screen of the sheet.

Hi Ed, Thanks for your quick reply. The data has to run through some tests: a)is it the right contract b)was it an action or just a quote. I managed to test these but, when I need to include an "If" I have a problem with the FALSE part. If([corret data],INDIRECT("D"&row()),[problem]) Lee

Hello to all the experts :-) Here goes, On one side I have a few rows of constantly updating Future-Contracts values, recent data comes into top line, all rows move down, lasst row vanishes. On the other side I want to have a list of the various contracts and their most recent values. For...