By looking up only unique donors and the header from A in this upside-down range, the first match found will always be their most recent donation. We VLOOKUP only those values in another virtual range: a QUERY of the A:C data upside-down by date (i.e., with the most recent dates always on top). ![]() (This will also include one blank, since that would be unique in the column one time.) Just be sure to format the resulting date column as dates, since by default is will use the raw number format of the data (i.e., the number of days since December 30, 1899, which will be numbers in the mid-40,000 range).Įssentially, we form a virtual range of just the UNIQUE donors (as well as the header) with UNIQUE(A:A). =ArrayFormula(IFERROR(VLOOKUP(UNIQUE(A:A),QUERY(A:C,"Select * Order By B Desc",1),FALSE))) Here is another approach (assuming the date is in A1:C):
0 Comments
Leave a Reply. |