I have a range of regions and stores and I need to use COUNTIF to pull out a "1" for the regions and a "0" for the stores. So for one column I have a list of the regions only, and the other column has the regions and the stores underneath in a hierarchy. My dilemma is that some of the stores have the same name as the region, and the only way they differ is that the regions are lowercase and the stores are all caps. I have searched and searched, but could not find anything that meets what I need.

Example:

Albuquerque 1 Albuquerque Albuquerque
Atlanta 0 ALAMEDA
Augusta 0 CENTRAL SW
Austin 0 GRIEGOS
Birmingham 0 WYOMING
Charleston 1 Atlanta Atlanta
Charlotte 0 BANKHEAD
Chattanooga 0 CONYERS
Cincinnati 0 DORAVILLE