Lets say I use column A to keep a daily run of my portfolio value. A1 would be Jul 1 value, A2 would be Jul 2 value and so on down the column. Now in cell D1 I want displayed the current days value(last cell value in column A). Is this possible to do with excel?
Thanks
Thanks