Array Formula to get last filled cell address in a given range
Code:=ADDRESS(MAX(IF(LEN(A1:I36)>0,ROW(A1:I36))),MAX(IF(LEN(A1:I36)>0,COLUMN(A1:I36))))
Array Formula to get last filled cell address in a given range
Code:=ADDRESS(MAX(IF(LEN(A1:I36)>0,ROW(A1:I36))),MAX(IF(LEN(A1:I36)>0,COLUMN(A1:I36))))
Posting Permissions
Reply With Quote
Bookmarks