Finding Latest Date of Multiple Transactions per User Using MAXIFS

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

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Maxifs only available in Excel365 or Excel2019.

Please try
=AGGREGATE(15,6,$B$2:$B$29564/($A$2:$A$29564=D3),1)

or
=MAX(IF($A$2:$A$29564=D3,$B$2:$B$29564))
Press Ctrl+Shift+Enter

Originally Posted by heyhsia

Modifying the Thread Title

Thanks, but you changed the wrong post in the thread. I have updated the opening post accordingly.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.