Last non-blank row
=LOOKUP(2,1/(E1:E100<""),E1:E100)
"awreet" wrote:
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.
|