Forum Discussion
Defined names change when looking them up in the name box
- In Spanish Excel, the formula should be:
=DESREF(Hoja1!$A$1:$A$1000;COINCIDIR(MAX(Hoja1!$A$1:$A$1000);Hoja1!$A$1:$A$1000;0)-1;0;1;1)
See: https://en.excel-translator.de/translator/
I don't know if it's different in the Spanish version but I need semicolons to separate the parameters.
I register a new name AN refering to your formula.
When I press F5 and introduce AN it gives me this message, reference not valid. There are values on all cells, so I don't know what the problem might be.
PD: When you have a defined name refering to a cell, you can find it with the name box as well, so my problem is if this is possible and I'm doing it wrong rather than using the name box.
=DESREF(Hoja1!$A$1:$A$1000;COINCIDIR(MAX(Hoja1!$A$1:$A$1000);Hoja1!$A$1:$A$1000;0)-1;0;1;1)
See: https://en.excel-translator.de/translator/
- Ok, thanks again!
- If you need to get the English translation of the formula in your current cell do this:
- Select the cell with the formula you want translated
- Press alt+F11
- Press control+g
- type:
?Activecell.formula
leave the cursor in that first line and press the Enter key. Thanks!! It needs at least one value in order to work fine which I was hoping it wasn't necessary. And I'm sorry I insist in the name box, but it also works and that is easier for what I want to do.
Thank you again for taking the time and I'll definitely use the translator next time, I didn't know it existed!