Warzel,

d/l my translateIT addin.
that allows for instant translation of pasted formulas
from and to Dutch (and many other languages)

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Warzel wrote :

That is not working, it only shows the names that only apear once
in the list. If a name has more then one entries it is not
displayed at all. further more is it not possible to do this in
VBA.


That isn't true. Sounds like you didn't type the formula correctly.

It will show an X for the *first occurrence* of a name in the list.
The 2nd or 3rd occurrence of the same name will look blank. In
other words, if you extract only the rows with an X, you will have
all of the unique names -- same result as the Advanced
Filter/Unique Records only.

Yes, of course you can do this in VBA, either by coding the steps I
described or, more efficiently, by using Advanced Filter.

You can also use "brute force" method: reading the two columns
into a VBA array, concatenating the first and last names into a 2nd
array, then comparing each entry to those above it in the list (I'd
use MATCH) and copying the 1st occurrence to yet a 3rd array.

Oke as i'am dutch i have a dutch version of excel, copying and
pasting of your example (like many examples here) give an error
message.

The formula in dutch is
=ALS(AANTAL.ALS(A:A;A1)=1;"x";"")

The IF statement is know as ALS
COUNTIF i think is AANTAL.ALS

notice the ; instead of the , using , wil create an error here