me address.
Regards from
Tom :)
--- On Sat, 10/12/11, MiguelAngel wrote:
From: MiguelAngel
Subject: Re: [libreoffice-users] Identifying the correct row in Spreadsheet
formulas
To: users@global.libreoffice.org
Date: Saturday, 10 December, 2011, 16:11
El 10/12/11 10:28, Ian Whitfield escribió:
> Th
El 10/12/11 10:28, Ian Whitfield escribió:
Thanks to Brian and the others who have now "put me right" and shown me
the right way to start a new Thread!!!
Regarding the 'Signature' I was going along with what I found in the
'TDF/LibreOffice Mailing List Netiquette'...
/"Signature/
/Always 'sig
Thanks to Brian and the others who have now "put me right" and shown me
the right way to start a new Thread!!!
Regarding the 'Signature' I was going along with what I found in the
'TDF/LibreOffice Mailing List Netiquette'...
/"Signature/
/Always 'sign' your message with your name and y
2011/12/9 Pedro :
> Hi Ian
>
> I think a VLookup function might help. But I'm not sure I understood your
> problem. Can you post a link to an example file?
>
> Cheers,
> Pedro
>
>
> Ian Whitfield wrote
>>
>> Hi All
>>
>> I have a spread sheet in LO 3.4.3 where I record and analyse monthly
>> number
Hi Ian
I think a VLookup function might help. But I'm not sure I understood your
problem. Can you post a link to an example file?
Cheers,
Pedro
Ian Whitfield wrote
>
> Hi All
>
> I have a spread sheet in LO 3.4.3 where I record and analyse monthly
> numbers and amounts for a electricity bill
Ian,
The "If 'Month'=Jan then Row=1" relationship can be a VLOOKUP, MATCH and
INDEX family of spreadsheet functions. I have sometimes used the INDIRECT
functions but these get very cumbersome and fragile.
This looks like it would be better done as a query in Base. I used
combinations of
Il 09/12/2011 14:11, Ian Whitfield ha scritto:
> On 09/12/2011 14:31, Marcello Romani wrote:
>> Please start a new thread instead of responding to an already existing
>> thread. To know more about what I'm talking about, please search "thread
>> hijacking" in google.
>> You'll increase your chances
quot;To" field.
Many apologies for the "support" so far! Hopefulyl someone might actually
answer the question at some point!
Regards from
Tom :)
--- On Fri, 9/12/11, Ian Whitfield wrote:
From: Ian Whitfield
Subject: Re: [libreoffice-users] Identifying the correct row in Sp
On 09/12/2011 14:31, Marcello Romani wrote:
Please start a new thread instead of responding to an already existing
thread. To know more about what I'm talking about, please search "thread
hijacking" in google.
You'll increase your chances of getting an answer.
Thanks Marcello
I was/am under the
Romani
Subject: Re: [libreoffice-users] Identifying the correct row in Spreadsheet
formulas
To: users@global.libreoffice.org
Date: Friday, 9 December, 2011, 12:31
Il 09/12/2011 13:12, Ian Whitfield ha scritto:
> Hi All
>
> I have a spread sheet in LO 3.4.3 where I record and analys
Il 09/12/2011 13:12, Ian Whitfield ha scritto:
> Hi All
>
> I have a spread sheet in LO 3.4.3 where I record and analyse monthly
> numbers and amounts for a electricity bill.
> The figures for each month are all in one Row.
>
> Below this I have "Allocation Blocks" that allocate the top figures t
Hi All
I have a spread sheet in LO 3.4.3 where I record and analyse monthly
numbers and amounts for a electricity bill.
The figures for each month are all in one Row.
Below this I have "Allocation Blocks" that allocate the top figures to
different sub-users.
Like this...
A BC
12 matches
Mail list logo
