Last non-blank row
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. |
Last non-blank row
|
All times are GMT +1. The time now is 04:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com