Using Excel 2007 in French.
Column A has alphanumerical values from A1:A1800
Column B has alphanumerical values from B1:B380
Most of the cells contain a first part "F13450" where the number following the letter F changes through the whole column A but what follows this is a phrase, like (example: F13450-Apple_brown_english.dotx)
In column B, I will probably will have the same data (example: F13450-Apple_brown_french.dotx) But the difference will be in the name. In this example, the difference is the word "french"
Basically, i would like to know which file name (these are actually Word files in two separate directory on my PC) I do not have in my column B. Of course I do not have the same amount of lines which is normal. I would like Excel to indicate which "F13450" file is missing from my list in B. I hope this was clear enough!