How do i lookup for last available data in excel?
Hi guys,
i need help to work on an excel formula to lookup for last transaction. my sample is below. I need to lookup for previous data (date and status) but cant find a solution.
Current Transaction Previous Attempt
Date Ref Status Date Status
Jan-2017 123 Unsuccessful - -
Jan-2017 abc Unsuccessful - -
Feb-2017 123 Successful 01-2017 Unsuccessful
Feb-2017 abc Successful 01-2017 Unsuccessful
Mar-2017 123 Successful 02-2017 Successful
Mar-2017 abc Successful 02-2017 Successful
Apr-2017 123 Successful 03-2017 Successful
Apr-2017 abc Unsuccessful 03-2017 Successful