- Joined
- Jul 18, 2016
- Messages
- 7,085
Does OpenOffice Calc genuinely operate with spreadsheet formulae in the predictable ways that Microsoft Excel manages to?
Not sure, I have only briefly used Excel.
Mytho,
I have MS works (somewhere on a hard drive as well as a genuine CD) but that wouldn't get me to the answer; it will only shift it to a different application.
I'll try and explain it a bit better..
A B C D E
1 8 5 4 5
2 4 7 2 9
3 8 9 5 4
4 5 3 6 2
5 8 4 5 4
6 6 1 4
8 6 2 7
9 7 4 3
10 4 4 8
I wish to create column 'E' .
And the first instruction (after highlighting the cell E1) would be =(B1).
Now , I wish to the contents of cell B3 into E2. That would be (B(1+2)) into E2.
Done manually it is pretty straight forward, but that entails entering the formula into every column E cell; all five of them in this case.
The idea is to increment the value of (B) in steps of 2. Thus extracting every second value in the B coulmn and using this data to create column E.
I have some thousands of data points in columns around 200 cells deep. So really need to automate this.
Hope this sheds some light on things.
INT21.
Just noticed I have missed Row 7.
Last edited: