compare values
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.
|