MAX function with conditions

I need some help with a formula. I am trying to find the max date from a list of names. I need the max date for each unique name, but each may name occur multiple times. Here is an example

Number Name Date
1 John 11/22/11
1 John 11/24/11
1 John 12/22/11
2 Mike 01/13/11
2 Mike 03/22/11
2 Mike 11/24/11
3 Bill 11/24/11

I need to find out which is the max date for John, Mike, and Bill based upon the number column. I have tried to use some array formulas but can't get it right. I am saying this because I have hundreds of dates/names/number combos and need to pull out the max date for each combo.

Any idea on how to do this?

Thanks Daddylonglegs, that worked out perfectly. One more question is there a way I can return the position of the cell of the max date? Or add another IF qualification to the original formula to not return a date without a code attached to it. example:

Name Date Code
Mike 10/24/10 WRK
Mike 11/24/10 "blank"

I do not want to return the date if the code is blank.