I am trying to get your formula 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'?

Thanks so much for the help.









"Harlan Grove" wrote:

Alan Beban <unavailable wrote...
If the functions in the freely downloadable file at
....

=ArrayCount(ArrayUniques(VLookups("AVRT",A1:C8,3) ))
....

Better idea for the OP would be using Laurent Longre's MOREFUNC.XLL
add-in, available from

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

then using the formula

=COUNTDIFF(IF(A2:A8=E2,C2:C8),,FALSE)