[PLUG] LibreOffice spreadsheet question...

Michael Rasmussen michael at jamhome.us
Sat May 11 20:03:57 UTC 2013


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, Portland Oregon  
          Be Appropriate && Follow Your Curiosity
  Other Adventures: http://www.jamhome.us/ or http://gplus.to/MichaelRpdx
A special random fortune cookie fortune:
Newer != Better
    ~ http://someoneoncetoldme.com/gallery/01062008



More information about the PLUG mailing list