On Sun, 5 Mar 2006 19:36:44 -0000, "Roger Govier"
<roger@technologyNOSPAM4u.co.uk> wrote:

>Assuming the dates are in column A, and the names are in column B, then
>create a helper column with the following array entered formula
>
>{=IF(A1=MAX(($A$1:$A$120000)*--($B$1:$B$120000="Fred Bloggs")),1,0)}
>
>To enter an array formula, commit with Ctrl+Shift+Enter. Do not type the
>curly braces { } yourself, Excel will enter them when you commit, or
>amend, using Ctrl+Shift+Enter.
>
>Copy down the helper column.
>Then, Data>Filter>Autofilter and use the dropdown on the helper column
>to Select 0
>Mark the range of Visible rows and Delete.

Thankyou very much. I'll make a copy of the file and test this out.
Regards,
V.