jdpicou1 asked:


I am building a spreadsheet to backtest Forex trading strategies.

I want to be able to find the difference between the circled values. Ideally to put the value in cell L93.

http://img205.imageshack.us/img205/4206/yahooal4.jpg

The only hard part is that there is not always 3 rows between each number to be used. Sometimes there may only be 1 row, or there may be 10 rows.
Is there a way for excel to fetch values between two of the same number? Like between 0’s?
I am asking b/c I need to do this hundreds or maybe thousands of times. I can find the difference between the sums of each of the two columns easily, but I want to be able to do this also.

Thanks

Technorati Tags: , ,