Thread: compare values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dirk dirk is offline
external usenet poster
 
Posts: 3
Default compare values

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.