Old but kuldgy way - only filter the single column of names (copied to a new
location) then use VLOOKUP (or other techniques such as OFFSET/MATCH) to pull
the other values in for each name

if you have Excel 2007 you can use the "Remove duplicates" function on the
data ribbon which allows you to define which fields to check for dupes, in
your case you tick just the name column and the second instance of Henk would
be removed.

"Henk" wrote:

I know how Advanced Filter Unique works, but I would like to have something
different. Suppose I have a little table like this :

Henk 1 4 6 7
Koos 2 5 7 1
Toos 4 3 2 4
Henk 1 5 7 3

If I use Advanced Filter Unique records, the result will be the same as the
tabel itself, because the table contains unique records only. But I want to
see Henk only once with data 1 4 6 7, or with 1 5 7 3. E.g.

Henk 1 4 6 7
Koos 2 5 7 1
Toos 4 3 2 4

How do I do this?

Thanks in advance filter,

Henk