simple cell equation, I hope

  • Thread starter Thread starter LWhite
  • Start date Start date
L

LWhite

I have a colmun (A) that is being populated from outside
of excel. The number of cells filled with a value is
variable. Sometimes the column will fill down to [A15]
and other times down to [A150]. I want to have the value
of the last filled cell appear in [B1]. so I am looking
for something like [B1]=A?

If I use [B2]=counta(A:A) then the output is the row
number of the last filled cell. Is there a way to then
write this so that I can have something like [B1]=A(b2)
or is there a better command to use?

I am using [] to indicate the cell the formula is typed
into, it is not a part of the formula.

Thank you for any help.
LWhite
 
I have a colmun (A) that is being populated from outside
of excel. The number of cells filled with a value is
variable. Sometimes the column will fill down to [A15]
and other times down to [A150]. I want to have the value
of the last filled cell appear in [B1]. so I am looking
for something like [B1]=A?

If I use [B2]=counta(A:A) then the output is the row
number of the last filled cell. Is there a way to then
write this so that I can have something like [B1]=A(b2)
or is there a better command to use?

I am using [] to indicate the cell the formula is typed
into, it is not a part of the formula.

Thank you for any help.
LWhite
Click to expand...

And if there can be blanks, then the array-entered formula:

=INDEX(A1:A1000,MAX(NOT(ISBLANK(A1:A1000))*ROW(INDIRECT("1:1000"))))

To array-enter a formula, hold down <ctrl><shift> while hitting <enter>. XL
will place braces {...} around the formula.

Replace 1000 with the largest possible row number.




--ron
 
Back
Top