Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare values
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare values
Create a helper column, say C, header in C1: Frequency, formula in C2:
=COUNTIF(B:B,B2), fill it down to the last row, DataFilterAutofilter, choose Custom from column C dropdown list, set condition to greater than 1. Regards, Stefi €ždirk€ť ezt Ă*rta: 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare values
Stefi,
that is correct, i only want those that occur more than once. gr. dirk. "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
compare values between workbooks and copy values | Excel Programming |