Results 1 to 8 of 8

Finding Latest Date of Multiple Transactions per User Using MAXIFS

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2018
    Location
    California
    MS-Off Ver
    Office 2013
    Posts
    35

    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
    Attached Files Attached Files
    Last edited by AliGW; 07-24-2019 at 12:53 AM. Reason: Thread title changed.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Second highest using maxifs
    By GIS2013 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-14-2020, 09:04 PM
  2. [SOLVED] MAXIFS and MINIFS not available
    By TFiske in forum Excel General
    Replies: 7
    Last Post: 05-08-2019, 11:27 PM
  3. Maxifs from Sumifs
    By zico8 in forum Excel General
    Replies: 3
    Last Post: 02-22-2019, 04:52 PM
  4. MAXIFS with OR criteria
    By HalPlz in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-06-2019, 03:24 AM
  5. MAXIFS with criteria
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 01-25-2017, 10:14 AM
  6. [SOLVED] MaxIFs help
    By Hondahawkrider in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-25-2016, 02:23 PM
  7. MaxIFS help
    By Hondahawkrider in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-06-2016, 03:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1