How can you compare a range of cell with one cell? You have log!R4:R65536=BC3
which say compare on worksheet log the cells R4 to R65536 with the cell BC3.
this will not work.



"Averitt Engineer" wrote:

I am trying to get a formula from

http://xcell05.free.fr/english/

to work, but I keep getting 'FALSE.' This is
my formula

=COUNTDIFF(IF(log!R4:R65536=BC3,log!T4:T65536),,FA LSE)

And this is a sample of my columns


(col R) (col T)
Carrier BOL #

GIST (BAH) 104502
GIST (BAH) 104502
GIST (BAH) 104502
AVRT 104501
AVRT 104501
AVRT 104501

I would like to know that there is one AVRT BOL in that list. Why is this
returning 'FALSE'?