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
_______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
