Excel Questions: using match

[sdemtevym]

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/download.do?get=f944d0055ccd89d926a83fbe2b174502

 

[Jacob Skaria]

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)

 

[sdemtevym]

Thanks for replying, but that didnt help me.
I have 584 unique image numbers in column F, so I should logically have 584
FALSE OR TRUE, depending on how the formula is written, but at the moment
I have 508 TRUE and 507 FALSE, which is wrong.

 

[Jacob Skaria]

I have had a look at the file...There are 77 items in ColF which are not
there in ColA

eg: 30308049

 

[John]

Hi
I'm using this =ISNUMBER(MATCH(F2,A$2:A$1200,0)) Will give True for Match, False
no Match
then =COUNTIF(B:B,FALSE) and get 77
=COUNTIF(B:B,True) and get 508
Is this what you want ?
HTH
John