I have uploaded the file, i need to compare the data in columns A and F. A
being a master list of numbers, F being the current list. I need to display
True or False in column B if the number is present or not and also calculate
how many we are missing etc. Currently it is not outputting the correct value.

http://www.quickfilepost.com/downloa...a83fbe2b174502