Find Missing Data Using COUNTIF
Nested in
IF Function


Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 



In
Column A I
have a list of cities in which my customers reside. In column B I have
tried to note down all the cities where my customers reside but I am
sure I have missed some because the list is quite long. How
can I
extract the city names from column B which I have missed without
searching for them manually? Is there a function for that? Thanks :)! The user most probably means how to find the missing city names from column A. We do this as follows:


Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
