Excel 2000 Automatically find last item in column of nums 1

[groverno1]

Howdy.

Is there a way for Excel to automatically find the last entry in a column? For example:
Data
14
15
16
17
18

What I want to be able to do is set up a formulat so that it subtracts the first number--i.e., 14--from the last number where new data will be continually added to the end of the column--i.e., today it is 18-14, tomorrow it will be 19-14, etc.

Thanks

Darren

 

[Zathras]

Assuming:
you know the cell coordinates of the first number in the list,
and there are no other data below the last number in the list,
and there will be no gaps in the list,
and you won't have more than 995 items in the list,
then this formula gives you the value from the last item (Assumes the first number is in cell A4):
[blue]

    =INDIRECT("A"&ROW(A4)+COUNT(A4:A999)-1)

[/color]

 

[groverno1]

Hot diggity dog!

Much obliged!

Darre