Hi,

I need help in setting up a formula that will compare two columns and return
a count of cells in column A that are not in column B. Making this a bit
more challenging, a cell beside it must meet a criteria.

Example:
assuming AB and CD are two period's worth of data

Column A Column B Column C and
Column D
Carmen Dallas Carmen
Dallas
Jenny Houston Jenny
Houston
Mike Ohio Terry
Ohio
Terry Dallas


I'd like a count of all those people in Dallas that are in column A, but are
no longer in Dallas in column D

How would it work?

Thanks,
Carmen