sheriff

thanks a lot! exactly what i needed

Hi all I have the following data Doc# Date 1 2 Jan 2007 2 10 May 2007 2 14 May 2007 I want the latest entry for each document. Results should look like this: Doc# Date 1 2 Jan 2007 2 14 May 2007 How do I go about doing this? Thanks in advance