generalledger
New member
- Joined
- Oct 15, 2016
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Location
- New Jersey, USA
- Excel Version(s)
- 2016
I have a table of transactions that include Date and Customer ID. How can I find for a transaction, the next transaction for the same customer?
For example, a customer might have several transactions over several dates. If I look at any one of those transactions, I need to find the very next dated transaction.
Date-----Next Date
1/1/19--1/15/19
1/15/19-2/2/19
2/2/19--2/3/19
2/3/19--(blank)
Thank you.
For example, a customer might have several transactions over several dates. If I look at any one of those transactions, I need to find the very next dated transaction.
Date-----Next Date
1/1/19--1/15/19
1/15/19-2/2/19
2/2/19--2/3/19
2/3/19--(blank)
Thank you.