Selecting the bottom cell of a table

[silentbob30]

Hello

Feel guilty for asking this as I am sure it is very easy but I cant think how best to do it

I have set of date and the last cell in column A is 2000. In A2 I want a forumla that will always point to the last cell in that column and displays the value. THe set of data will vary in length so A2 always needs to to select the last cell in its column.

 

[VoG]

Try

=LOOKUP(9.9E+307,A3:A10000)

 

[JamesW]

Hi,

To find the last TEXT value use:

=INDEX(A:A,MATCH(REPT("z",255),A1:A2000))

To find the last NUMERICAL value, use:

=INDEX(A1:A14,MATCH(9.99999999999999E+307,A1:A2000))

If you arn't sure what the last value is (either TEXT or NUMERIC) then use:

=INDEX(A2:A2000,MAX(MATCH(9.99999999999999E+307,A2:A2000),MATCH(REPT("z",255),A2:A2000)))