I'm having trouble filtering a set of data containing Note history. Several notes may be left for the same ID, but I want to pull only the most recent notes left, for each unique ID.

CodePudding user response：

try:

=ARRAYFORMULA({'Data - All'!A1:P1; IFERROR(VLOOKUP(UNIQUE('Data - All'!A2:A), 
 SORT('Data - All'!A2:P, 13, 0), SEQUENCE(1, 16), 0))})