Excel 2010 - Show Items Missing In One Column Compared to Another Column
Posted on 2014-12-19
I have to columns in Excel Column A and B which contain thousands of rows. I need to list all items that are missing from columns B using Column A as a reference. I was hoping all missing items could be listed in column C.
I setup Conditional Formating which works my is no easy to go though. I have read online that you can setup a formatting rule as well but no exactly what I am looking for.
I am not the excel as advanced Excel items an great full for any help provided.