Hi all,
I am trying to create a formula that will return the values that are highlighted in red in the below screenshot but am not having much luck. Basically, I would like to return the previous transaction value for that particular stock. If there has been no previous transactions for that stock, I'd like the cell to be blank & if I have purchased the stock in the past, I'd like the cell to return the last transaction value for that particular stock.
Does anyone have any ideas how I can do this?
I am trying to create a formula that will return the values that are highlighted in red in the below screenshot but am not having much luck. Basically, I would like to return the previous transaction value for that particular stock. If there has been no previous transactions for that stock, I'd like the cell to be blank & if I have purchased the stock in the past, I'd like the cell to return the last transaction value for that particular stock.
Does anyone have any ideas how I can do this?