The LAST number

[hirschb]

Is there a function or formula in Appleworks that can find the LAST number in a range of cells and copy it to a distant cell? Short of a function, is there any other way to do it without actually looking for it?
Thanks for your help,
hirschb

[Barry]

Is there a function or formula in Appleworks that can find the LAST number in a range of cells and copy it to a distant cell? Short of a function, is there any other way to do it without actually looking for it?

It can be done using a combination of functions.

In the example, the values are in the cell range B1..B50, and "LAST" is defined as the value contained in the row furthest down the table, regardless of empty cells above it.

In A1, enter either:
=IF(B1,ROW(),"") (this will ignore zeroes as well as blank cells)
OR
=IF(LEN(B1)>0,ROW(),"") (this will include cells where a zero has been entered)

Fill the formula down to A50.

In the cell where you want the LAST number copied, enter:
=INDEX(B1..B50,MAX(A1..A50),1)

Regards,
Barry

PS: For details on the INDEX function, see INDEX in the Alphabetical list of functions in AppleWorks Help.


=INDEX(B1..B50,MAX(A1..A50),1)

[hirschb]

Berry,
I would like to say thank you for your reply. I have not yet had a chance to use the information you provided but I,m sure I'll get to it in the next day or two. Just a "thank you very much".
hirschb