Find all items on list B that are not on list A, Excel.
<p>I have list A with 259 items and list B with 626 items. There is some overlap between the list, so I want to find all items on list B, which are not on list A. I've been trying to find some info on how to do it in Excel on the Net, but I cant figure it out. Would you be able to give me the best and the easiest way of doing it, and also explained on how to do it (like people say "copy the formula down to all the rows", but I am not sure how would I do this). </p>

<p>Thanks. </p>