Dave,

I that works, but that is exactly what I do not want. I want the data next
to the unique Henk (one ore the other), not only Henk.

Anyhow, tHenks for your reply.

"Dave Peterson" wrote:

Make sure your list range is only column A.

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

--

Dave Peterson