Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |