compare values

D

dirk

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.
 
J

Jim Cone

See your other post.
--
Jim Cone
Portland, Oregon USA





"dirk" <[email protected]>
wrote in message
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.
 
Top