Hi all:

I've a fairly lengthy set of data, but I'm primarily concerned with 3
columns. For my example, let's say that

ID number is in column A, Date of action is column B, Action type is column C.

On another sheet I would like to look up whatever action was the most recent
for the respective ID number. I'm not certain how to do this without doing
some sort of sort then remove duplicate to create another list that would
only have the most recent action. This seems a shoddy way of going about it.

Is there a way to insert a MAX function in to the date criteria for a lookup
or sumproduct function or index?

Many thanks in advance.

Brad