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
1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

How do i lookup for last available data in excel?

by watsonjohn759 In reply to How do i lookup for last ...

On the off chance that you have to discover the estimation of the last non-discharge cell in succession or section, you can utilize the LOOKUP work in this shockingly smaller recipe. As an extra reward, this recipe isn't an exhibit equation, and not unstable.

Back to Tips and Tricks Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums