is a choose() nested in a vlookup() which is nested in another
vlookup(). Bad code all around.
Thanks for your time!
El 07/08/2014 a las #4, Daniel R. Miguel escribió:
Hi again!
I have a problem in Calc. I get a lot of spreadsheets from various
sources and I have to compile one big sheet wit
Hi again!
I have a problem in Calc. I get a lot of spreadsheets from various
sources and I have to compile one big sheet with the information of
every one of them. One of the problems I am facing is that there is a
lot of names for the same user. So, for example:
PHONE EXTENSIONName Shee
Hello again!
I realized the error was that the decimal point is a , (we are using
Spanish localization), so changing the , for a . decimal point did the
trick.
Once again, thank you a lot.
El 05/08/2014 a las #4, Daniel R. Miguel escribió:
Hi again,
I modified the formula to suit my
OT6
OT5 OT5 OT8 OT5 OT6 OT3 OT8 OT8 OT4 OT8 OT8 OT5 OT1 OT5
OT4 OT8 OT8
Is the HF8 the one to blame?
Thanks again.
El 05/08/2014 a las #4, Brian Barker escribió:
At 17:38 04/08/2014 +0200, Daniel R. Miguel wrote:
I have a table with cells that may contain OTnum, so it mig
Hi, I have a table with cells that may contain OTnum, so it might
contain OT0.5, OT1, OT2, OT2.5 et cetera.
I would want to sum the number substring of all the cells in a row, so
for example if I have this row:
AlanOT0,5FOT1FVOT2FFVOT3
I would have ano