Forum Discussion
Solved
Automatic Translation from "F" Fila in Spanish to "R" Row in English
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...
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
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
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
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
Many thanks, it works perfectly