tpowell1986
New Member
- Joined
- Jun 23, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
hi,
we have a list of products has have been reported lost, i want to look at the list of transactions on another sheet to see if there is any further transactions after the date it was reported lost?
thanks in advance
i.e.
we have a list of products has have been reported lost, i want to look at the list of transactions on another sheet to see if there is any further transactions after the date it was reported lost?
thanks in advance
i.e.
Vessel | Lost Date | Further Transactions | Vessel | date_out | |
7285165 | 08/04/2015 | 20/06/2021 | 7285165 | 01/01/2014 | |
7759616 | 08/03/2018 | 7759616 | 02/01/2014 | ||
7759645 | 08/12/2015 | 7759645 | 03/01/2014 | ||
7759723 | 08/01/2018 | 7285165 | 20/06/2021 | ||
7759789 | 08/08/2016 | 7285165 | 23/06/2021 |