Forum Discussion
Same City Names in different States
I have attached a sample file. Column A contains the cities. Some of them have same city names but their state names are different(column M). I want to add State abbreviation (Column N) to only those...
=IF(COUNTIF($A$2:$A$962,A2)>1,A2&"-"&N2,A2)
This is the formula in cell Q2 which combines PHYSICAL CITY and PHYSICAL STATE if the PHYSICAL CITY is a duplicate. The formula is filled down column Q.
Thank you so much. Appreciate your help.