how to get values out of spreadsheet and insert them to formula?

[ramssted b]

So, how do i open a spreadsheet which contains two columns and several rows of data and insert those values in to a formula? To be accurate A1 shell should be input 1 (X1), shell A2 input 2 (X2), shell B1 input 3 (X3) and shell B2 input 4 (X4). After calculation it should continue to the next row and take values out of A2,A3,B2 and B3 and so on, to the end of data. I´m using Labview 7.

[Jonnie_5]

Here's one (of probably many) ways to do it.

[ramssted b]

thanks Jonnie_5, your example is close, but doesn´t work the way i ment. It counts rows a and b, and then jumps to rows c and d, and so on. Not to rows b and c, c and d, and so on, as i would wanted to.

How can i make this happen? advises?

[Jonnie_5]

Sorry, I missed the overlapping portion of the pattern.

This one goes as follows:
First round: A1=x1, b1=x2, a2=x3, B2=x4
Second Round: a2=x1, B2=x2, a3=x3, b3=x4

Oh, and I'm using Excell conventions, so A=column1, 1=Row1, B=column2, 2=Row2

Cheers,
J5

[ramssted b]

YES! thanks Jonnie_5!!