I am trying to get the last row which is filled based on column B. I mean i have data in a sheet in which (for example B45 is the last filled row because it is merged with C45, D45 etc). So, I want to get that B45 to be the result if I put the formula in D100.
I ope I am clear. I dont want the data in B45 but I want the result to be B45.
Bookmarks