Data Spreadsheet Question

[jonpaul_iasg]

This has probably been asked before...but any help is appreciated with the following:

I would like to know the function for taking the last figure in a column and placing it (for summary purposes) in another cell.

My spreadsheet has 100's of rows of data and summarizing with a lookup function seems to be the answer...I'm just not sure how...

For Example: I would like to take the value of Row 5 and place in another cell. Each day I add a new row so having a lookup type function to grab the latest entry for certain columns is key.

Row 1 - 5/22/2011
Row 2 - 5/23/2011
Row 3 - 5/24/2011
Row 4 - 5/25/2011
Row 5 - 5/26/2011

[scottylad2]

Assuming your data is in column A and you will always be looking up a Date number try
=LOOKUP(9.9999999999999E+307,A:A)

[jonpaul_iasg]

I used the date as an example...actually the figures will either be $ or % and most will have Formula attached to them

[scottylad2]

as long as the number your looking up is numeric that will work

[jonpaul_iasg]

I cannot seem to make it work with the formula you provided...Here is an actual column from one of my sheets. I wan't to take the last %...in this case 0.15% and put in a cell directly above the Daily column label.

Daily

-0.03%
0.09%
0.10%
0.28%
0.03%
0.03%
-0.01%
0.16%
0.35%
-0.02%
0.12%
0.13%
-0.18%
0.02%
0.34%
0.26%
0.11%
-0.43%
0.48%
0.36%
0.13%
0.15%

[jonpaul_iasg]

actually I forgot to change the column...duh...it worked!! Thanks for your help!

[arthurbr]

Works perfectly for me. The question then is, is your data numbers or text looking like numbers ?

If so =INDEX(A:A,MATCH(REPT("Z",255),A:A)) will work if you want to keep it as text or =INDEX(A:A,MATCH(REPT("Z",255),A:A))*1 it you want to convert to number