Excel - Find values that dont have a second value : This one is a bit complicated. Below is a sample data structure. Essentially, I am looking for a list of column A where there isn't a specific value in column B as well as any other value in Column B.

Example:

    COLUMN A        COLUMN B
    LEFT            ALPHA
    LEFT            BETA
    LEFT            CHARLIE
    RIGHT           BETA
    RIGHT           CHARLIE
    UP              ALPHA
    UP              CHARLIE
    DOWN            BETA
I want to know all Column A Where There is an Alpha and at least one other value for Column A. So Left has an Alpha and another value that's not alpha so it would be included. Right doesn't have an alpha so auto excluded. Up has an Alpha and another value that's not alpha so it would be included. Down has no alpha and is excluded. This can populate the list on another worksheet that would be best. I think I have to go the Macro VB route but Im unsure where to even start.

I hope this makes sense. Sorry if it doesn't but please feel free to ask clarifying questions. I really appreciate your help.