Averitt Engineer wrote...
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),,F ALSE)

I can't get COUNTDIFF to return FALSE. Zero (0), yes. FALSE, no.

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
....

Given the above (including the column headings and blank row) in R1:T8
(with col S blank), and with AVRT in cell W1 rather than BC3, the
array formula

=COUNTDIFF(IF(R3:R8=W1,T3:T8),,FALSE)

returns 1 on my system. What version of MOREFUNC.XLL are you using?
Also, if you don't enter the formula as an array formula, it'll return
#VALUE!. Is that what you mean by FALSE? Also, it's possible there are
stray trailing spaces in either your col R values or your BC3 value.
You could try the array formula

=COUNTDIFF(IF(TRIM(log!R4:R65536)=TRIM(BC3),log!T4 :T65536),,FALSE)