I am trying to compare two columns - one has 187 cells with data, another has 204 cells with data, entries are text in both the columns, some cells do not have any data and some cells are repeated with same data randomly. I am trying to find out what are the data in second column that is not there in the first one. I am sure that second column has some data that is not there in the first column. Please suggest what formula I should use. Thank you very much for your help!