index and match

Based upon your example, what should your result look like. I am a bit confused -- are you looking for unique emails? So hotel619 would have two unique emails?

If you are looking for unique, what about hotel619 [email protected] Why is that excluded? Need to fully understand your logic model.

So the only criteria for your entire list is hotel619 and [email protected]? I am still confused by your request. Perhaps you need to explain your project in more detail. I am getting the feeling that this is not the only issue.

If I am understanding your request to filter out all identified criteria then this VBA should work for you. If this is not what you are looking for, then post back with a more detailed explanation of what you would do if you were to do this manually.

Please Login or Register  to view this content.

How to install your new code

• Copy the Excel VBA code
• Select the workbook in which you want to store the Excel VBA code
• Press Alt+F11 to open the Visual Basic Editor
• Choose Insert > Module
• Edit > Paste the macro into the module that appeared
• Close the VBEditor
• Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

• Press Alt-F8 to open the macro list
• Select a macro in the list
• Click the Run button