|You could try the COUNTIF function as follows:|
Enter this in B1 and drag it down:
You could also use ISNA and VLOOKUP:
If VLOOKUP returns a #N/A error, then the value wasn't found. The ISNA function checks for that error.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.