View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Averitt Engineer[_2_] Averitt Engineer[_2_] is offline
external usenet poster
 
Posts: 7
Default count unique values, if ...

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