Excel Index Formula
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..
__________________
G____G
G____GTevaG____G
Heart___G_Hessah_G___Heart
79 - Paladin | 85 - Enchanter | 91 - Scoutxx
Ninja text! For those who's easily amused
I can show you the woooorld!
I don't want to see it!
okay...
|