Do I need programming for this?

  • Thread starter Thread starter .NET Developer
  • Start date Start date
N

.NET Developer

Hello.

Can anyone please tell me if a function exists that returns the value at the end
of a row or column of cells? Or do I need to use programming?

For instance, say I have a column with 3 values:

3
55
135

The function in question will return 135.

If I add a few more numbers to the column, like this:

3
55
135
243
533

The function then automatically returns 533.

Thanks very much for any help.

- Robert.
 
If you will be entering data past row 1000, change this accordingly, up to
65535.

=INDEX(A1:A1000,MAX(IF(A1:A1000<>"",ROW(A1:A1000))))

This formula must be array entered - You must press ctrl+shift+enter (as
opposed to just hitting enter) after inserting the formula and subsequently
every time you edit the formula for it to work. If you do this correctly,
Excel will display the formula enclosed in curly braces {}.
 
=INDEX(A:A,MATCH(9.99999999999E+307,A:A,1),1)

Will give you the value entered in the last cell in column A.

for a row

=INDEX(10:10,1,MATCH(9.99999999999E+307,10:10,1))

Regards,
Tom Ogilvy
 
Back
Top