Last non-blank row

[awreet]

I thought I posted the following late this morning. I don't see it,
so I'll try again...

Hello:

I need to return the last non-blank row of text in a column from one
worksheet to a summary worksheet at the front of my workbook.

='Sheet1'!E4 works to return text from cell E4 of Sheet 1.

=index(e1:e100,max(row(e1:e100)*(e1:e100<>""))) supposedly returns the
last non-blank text from a row in a column.

However, when I combine the two I get an error:

='Sheet1'!index(e1:e100,max(row(e1:e100)*(e1:e100<>"")))

Can anyone educate me? Any feedback is appreciated...Thanks.

 

[Gary''s Student]

http://www.microsoft.com/office/com...&p=1&tid=05825452-d34a-40c8-9c15-0b6287fec3a6