Hello,
I have a list of Donors (Column A) who gave gifts on gift dates (Column B). There are multiple rows for donors who give more than one gift. Column D contains a list of unique donors. In Column E I'm trying to find the latest gift date for each unique donor.
I thought I could use the MAXIFS function to solve this problem, but it's giving me an error. I'd be grateful for advice on what I'm doing wrong in applying MAXIFS.
Thank you,
Paul
Bookmarks