[PLUG] LibreOffice spreadsheet question...

David Fleck david.fleck at mchsi.com
Sat May 11 20:03:58 UTC 2013


On Sat, 11 May 2013, 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.

Yes, this works great! Thanks to you and Bill for the suggestions.


--
David Fleck
david.fleck at mchsi.com




More information about the PLUG mailing list