[Hessah]

We have one column of data e.g.

A
B
C
D
E

And we're trying to have a cell that looks up the last cell in that column and display what's in that last cell, in this case, E.

I looked up Google, and someone gave this formula:

=INDEX(B7:B26,MAX(IF(LEN(B7:B26)>0,ROW(B7:B26),0)) ,1)
(And hit Ctrl Shift Enter, not sure what that does, but it doesn't work if we just hit Enter.)

It was working on a normal spreadsheet, but for some reason it doesn't work in the work document.. it keeps returning 0.

Anyone have any clue what has to happen for that formula to work properly?

Or even just explain what Ctrl Shift Enter does?


EDIT: There are page breaks involved in this spreadsheet.. if that makes a difference..