Hi All.
I have a spreadsheet which has a number of columns: Col A = series of dates, Col G has sporadic Dollar values (not all cells have values against the date).
I am trying to calculate the number of days between one date and the corresponding date in Col 1.
I use the formula to get the last value in col G : =(LOOKUP(2,1/(G4:G400<>""),G4:G400))
I am trying to get the corresponding value and cell address (Col A).
I am trying to look at the changes in dollar values over time based on share prices which I get on a sporadic basis..
An example would be Col A:
A4 = 07 May 2019, A5 = 08 May 2019 etc down to 01 Jan 2020
Col G
G4=$2000, G20 = $3540, G34 = $2560
So If col G is at 01 Dec 2019 then I am trying to get the address and value of col A.
Any help would be appreciated
Bookmarks