Question Locked

How do i lookup for last available data in excel?

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.