Automatic Translation from "F" Fila in Spanish to "R" Row in English

[Jose_E_Martinez]

Hi all,

I am using in some functions the letter "F" as Spanish reference to Row,

But when sharing my files with colleagues in US, UK or Germany, their excel do not recognize nor translate the "F" to "R" (Row),

So the Functions are not working for my colleagues

Exists any common code to define Row in all languages?

Or any way for Excel to automatically translate "F" or "R" to other languages? as it does with Functions

Thanks

Jose

[#2]

@Jose_E_Martinez 

Can you give an example of the formulas you are using? Translation won't be possible, though there may exist alternative, locale-independent solutions.

Regards

[#3]

Hi Jos
this is one example:

=INDIRECTO("F"&TEXTO(FILA()-1;"0")&"C"&COLUMNA();FALSO)+1

I would need the "F" and the "C" references to Row and Column,

to be translated or useful in all languages Spanish, English, German, French...

[#4]

Can I ask what the intended use for this formula is? Clearly it is simply referring to the cell directly above that in which the formula lies, so the question becomes: why are you going to such lengths to create such an indirect reference?

[#5]

Hi,

on my file there are other formulas more complex, also using this kind of references

=SI(AC13<>"";SI.ERROR(INDIRECTO("F"&COINCIDIR(INDIRECTO(BG13&FILA(AC13));$A:$A;0)&"C"&TEXTO(COINCIDIR("INI";$7:$7;0)+SI("F"=INDIRECTO(BH13&FILA(AC13));SI(INDIRECTO("F"&COINCIDIR($B13;$A:$A;0)&"C"&TEXTO(COINCIDIR("FI2";$7:$7;0);"0");FALSO)<>0;COINCIDIR("FI2";$7:$7;0)-COINCIDIR("INI";$7:$7;0);COINCIDIR("FIN";$7:$7;0)-COINCIDIR("INI";$7:$7;0));0);"0");FALSO)+SI(INDIRECTO(BI13&FILA(AC13))="+";1;-1)*$E13;0);0)

On the first example we need a system to be sure that if we introduce rows between our calculations this cell is always referring to just above cell

On the second example, it is difficult to explain how they work, as the file was created by somebody that left the company,

So I just trying to keep the file working and sharing it with my colleagues around the world

Thanks

[#6 · Accepted solution]

@Jose_E_Martinez 

So why can't you use simply

=OFFSET([ThisCellReference],-1,0)

For example, the formula in cell J10 would be:

=OFFSET(J10,-1,0)

Note that no circular reference is caused by this formula. And it will always refer to the cell immediately above it (though obviously in row 1 it will result in an error).

Regards

[#7]

@Jose_E_Martinez 

I guess your formula returns something like R6C5. Same could be returned by =ADDRESS(6,5,1,0) without F/R and C.

[#8]

@JosWoolley 

Many thanks, it works perfectly

[#9]

Many thanks for your answer