In cell B1 apply formula and copy down as required
=COUNTIF(F:F,A1)0

To find the total missing ones try this formula
=COUNTIF(B:B,FALSE)

--
Jacob (MVP - Excel)


"sdemtevym" wrote:

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