[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