count unique values, if ...

A

Averitt Engineer

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),,FALSE)

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'?
 
J

Joel

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

Averitt Engineer

=COUNTDIFF(IF(log!R4:R65536=$BC$4,log!T4:T65536),,FALSE)

=COUNTDIFF(IF(log!R4:R65536="AVRT",log!T4:T65536),,FALSE)

=COUNTDIFF(IF(log!R4:R65536=BC4:BC65536,log!T4:T65536),,FALSE)

don't work either. any suggestions?
 
Top