[PLUG] LibreOffice spreadsheet question...

Fred James fredjame at fredjame.cnc.net
Sat May 11 21:09:20 UTC 2013


Michael Rasmussen wrote:
> On Sat, May 11, 2013 at 03:59:31PM -0400, Fred James wrote:
>> Bill Thoen
>> I am trying to follow the solution in your first paragraph ...
>>
>> The second paragraph solution, and others I have seen so far, only count
>> the number of rows, or with a little modification the number of columns.
>>
>> But the original question was (I believe) to place the value found in
>> the last non-blank cell of a row, into the first cell of the same row?
>> As I understand it (and I may be wrong), that would be something like ...
>>
>> Row 1 has values in
>>       B=2
>>       C=40
>>       D=1
>> so we want cell A1 to contain the number 1, which is the value in cell D1
>>
>> Row 1 changes and has values in
>>       B=2
>>       C=40
>>       D=1
>>       E=75
>> so we want cell A1 to contain the number 75, which is the value in cell E1
>   
>
> What behavior do you want in this case:
>
>   B=2
>   C=40
>   D=<blank>
>   E=14
>   F=80
>
> The potential presence of blanks is what makes this a bit more complicated.
Michael Rasmussen
Back to the original poster and that question ... I am guessing that 
there wasn't supposed to be any blanks such as in your example.  But one 
would have to ask the original poster to be sure.
Regards
Fred James





More information about the PLUG mailing list