I've looked on the forum to see if I could find a solution. Sorry if it's already been asked as I could only find answers for two columns using =max

I have a worksheet with:
col 1, col2, col3
Name, Class, Class Date

I want to keep rows that have the same Name, and Class Fields but only keep the newest date. a pivot table isn't really acceptable for this.

here's an example:

joe, class 1, 01/01/11
joe, class 2, 01/02/11
joe, class 1, 02/01/11

and extract so that only the newest date apears
joe, class 2, 01/02/11
joe, class 1, 02/01/11

Thanks,
-j