How do i lookup for last available data in excel?

By DeN inc. ·
Tags: Microsoft
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Tips and Tricks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums