BigBeachBananas
Active Member
- Joined
- Jul 13, 2021
- Messages
- 450
- Office Version
- 365
- Platform
- Windows
- MacOS
Hi,
I have a list of names and paid-to-date year by year. I'm looking for a way to trim down the data and only get the latest paid-to-date. Please see the sample below. Thanks.
I have a list of names and paid-to-date year by year. I'm looking for a way to trim down the data and only get the latest paid-to-date. Please see the sample below. Thanks.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Sample Data | Output | |||||
2 | Name | Paid to Date | Name | Latest Paid to Date | |||
3 | Kim Young | 1/12/16 | Kim Young | 1/12/19 | |||
4 | Kim Young | 1/12/17 | John Jackson | 3/31/19 | |||
5 | Kim Young | 1/12/18 | |||||
6 | Kim Young | 1/12/19 | |||||
7 | John Jackson | 3/31/15 | |||||
8 | John Jackson | 3/31/16 | |||||
9 | John Jackson | 3/31/17 | |||||
10 | John Jackson | 3/31/18 | |||||
11 | John Jackson | 3/31/19 | |||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B4:B6,B8:B11 | B4 | =DATE(YEAR(B3)+1,MONTH(B3),DAY(B3)) |