Stefi,
this is correct
i only want a return of those files with the same name
the others i do not need.
thank you


"Stefi" wrote in message
...
What is the rule for omitting these two rows:
dossier 3 MIES
dossier 2 NOOT
The only difference I could discover is that MIES and NOOT occurs only
once.

Stefi


"dirk" ezt írta:

Hello,
i am looking for a function or macro that will help me out with te
following
problem :

I hav a file with 2 columns (filename and name):
FILENAME NAME
dossier 1 AAP
dossier 4 AAP
dossier 9 AAP
dossier 10 AAP
dossier 5 BOOM
dossier 7 BOOM
dossier 3 MIES
dossier 2 NOOT
dossier 6 VLIEGTUIG
dossier 8 VLIEGTUIG

i want to sort this out, so only the cells with the exact name in column2
and the corresponding filename will show up :
like this

dossier 1 AAP
dossier 4 AAP
dossier 9 AAP
dossier 10 AAP
dossier 5 BOOM
dossier 7 BOOM
dossier 6 VLIEGTUIG
dossier 8 VLIEGTUIG


thank you.