tpowell1986
New Member
- Joined
- Jun 23, 2021
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
I have a list of transactions containing product and sold dates, the same product may appear multiple times in the list with different sold dates. i would like to know how i can find the next time that product was sold after the date on the current line? thanks
Vessel | Sold Date | Next Transaction Date |
7285165 | 08/04/2015 | 08/01/2018 |
7759616 | 08/03/2018 | |
7759645 | 08/12/2015 | |
7285165 | 08/01/2018 |