Delete rows based on the values within two columns (CustID & Location)

[OmniBlue]

I would like to exclude records for all customers (CustID) other than those who:
1) Have at least two records with a specified Location, and
2) Have at least one record with a location other than the specified Location.

Please see the attached Excel file for a more clear description!

Is it possible that this can be accomplished with some combination of Excel formulae and sorting? Or is VBA coding required?

Thank you!

[ufopilot]

I used helper columns to set the criteria of having a minimum of 2 Rochester Locations, and one for all others.
There is a macro that will delete any rows marked with "x" in column A.

You could also just filter by "x" and delete the rows manually.
Another possibility is to not have the helper columns at all, and to put all the formulae into the macro, but it would take me quite a while to figure out the best way to write the macro for it to not be as crud as recording the formulae into the macro.

Perhaps a more advanced member on the site will have the answer and be able to have a clean code for this.

[OmniBlue]

Thank you, ufopilot! That looks like a great start! However, within my sample worksheet, I would need to delete all records except the final six (those for CustID 2556, who meets the two criteria); and it appears that the formula does not mark all of those for deletion. Or perhaps I misunderstood your response?