Hi Gurus,
I have data in column "A" as dates in series and some values in column "B". I want to get the last value in column "B" and get the corresponding ROW value from column "A".
________ _________
A B
----------- -------------
01.01.2019 Yes
02.01.2019 Yes
03.01.2019 No
04.01.2019 Present
05.01.2019 Yes
06.01.2019 No
I expect system should return - 06.01.2019 since the last non empty cell in column in "B" is "B6" and adjacent cell "A6" has - 06.01.2019
With warm Thanks
Shiva
Bookmarks