[PLUG] LibreOffice spreadsheet question...

[Fred James]

Denis Heidtmann wrote:
> INDEX(A1:Z1,1,COUNTA(A1:Z1),1)
>
> where it is assumed that the Z1 is as far in the row as your data could be.
>   Otherwise change Z1 to whatever you want.  Also, this assumes that there
> will be no blanks in the columns to the left of the last.
>
> -Denis
>
>
> On Sat, May 11, 2013 at 7:42 AM, David Fleck <david.fleck at mchsi.com> wrote:
>
>> I don't use spreadsheets very often, so my cell-formula-fu is quite
>> limited.  I'm trying to come up with a way of having a cell (let's call it
>> 'A1') contain the value of another cell.  That other cell will be the last
>> occupied column of row 1, and it will vary over time.  So sometimes I want
>> A1 to contain the value of E1, because that's the last occupied column;
>> but other times it should contain the value of W1, because that is the
>> last occupied column.  I rummaged through the Help, but didn't see
>> anything that obviously solved my problem.
>>
>> Can this be done?
>>
>> If so, can someone explain how?
>>
>> Thanks in advance.
>>
>> --
>> David Fleck
>> david.fleck at mchsi.com
>>
Denis Heidtmann
I am trying to impliment your interesting solution, but I keep getting ...
     ERR:508; Error:Missing pair,;"Missing bracket, for example, closing 
brackets, but no opening brackets "
Thank you for any further assistance you may be able to offer
Regards
Fred James