[Solved] I want to change text in Calc using wildcards

[rrvau1]

Please answer the following questions, along with describing your problem or question.

Which version of OpenOffice.org are you using: 2.3
What Operating System (version) are you using: Windows XP

----------------------------------------------------------------------------------
Your question: I am trying to construct a spreadsheet in which I need to average a particular column. I am using "average(J8:Jn)" where n is that last row that has been entered. If I enter this formula as average(J8:J9) and then copy down all column number increment, eg average(J8:J9) average(J9:J10)average(J10:J11)average(J11:J12) and so forth. However, what I desire is for the formulae to read average(J8:J9) average(J8:J10) average(J8:J11) average(J8:J12) etc. Using wilcards doesn't even find the desired text. How do I achieve this?

All suggestions gratefully received.

Royce




HEY GUYS, thank you all for your help, it is much appreciated. Problem solved.

Royce

[JohnV]

However, what I desire is for the formulae to read average(J8:J9) average(J8:J10) average(J8:J11) average(J8:J12) etc.

Your original formula should be
=AVERAGE(J$8:J9). The $ make 8 an absolute, rather the relative, reference.
http://user.services.openoffice.org/en/ ... 43&p=10658

[Villeroy]

[Tutorial] Absolute, relative and mixed references