Bill Thoen wrote:
> On 11-May-13 8:42 AM, David Fleck 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
>> [email protected]
> There's several ways to tackle this one. The easiest (but a little
> inelegant) would be to use a named range for the column or a named range
> in the cell one beyond the end. Then every time you insert a new row
> into your active data area, you would automatically expand the range or
> bump t6he marker cell down a row.
>
> Another solution (I haven't tested this myself yet, but it looks right)
> from the Minor Point blog offers a formula solution good for both calc
> and excel. You can read about it here:
> http://minorpoint.blogspot.com/2010/09/how-to-find-last-used-row-in.html
>
> Hope that does the trick for you!|
>
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
Row 1 changes again and has values in
B=2
C=40
D=15
so we want cell A1 to contain the number 15, which is the new value in
cell D1
Could you please, clarify your first paragraph solution, perhaps with an
example?
Thank you
Regards
Fred James
_______________________________________________
PLUG mailing list
[email protected]
http://lists.pdxlinux.org/mailman/listinfo/plug
