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 {}.

--
HTH,
Laura Cook
Appleton, WI


".NET Developer" wrote in message
om...
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.

=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



".NET Developer" wrote in message
om...
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.