With Power Query you can determine which people are current with in the past 365 days
Excel 2016 (Windows) 64 bit
|
G |
H |
I |
J |
14 |
Donor Last Name |
Donor Last Name2 |
Amount Description |
Last Renewal |
15 |
Abel |
Abel |
Artist |
7/23/2023 |
16 |
Alexander |
Alexander |
Friend |
1/24/2024 |
17 |
Ambrose |
Ambrose |
Artist |
3/31/2024 |
18 |
Anderson |
Anderson |
Artist |
8/23/2023 |
19 |
Anderson |
Anderson |
Friend |
9/20/2023 |
20 |
Bagatella |
Bagatella |
Artist |
9/9/2023 |
21 |
Bellamy |
Bellamy |
Friend |
11/29/2023 |
22 |
Collins |
Collins |
Artist |
9/28/2023 |
23 |
Craig |
Craig |
Artist |
11/14/2023 |
Bookmarks