count unique values, if ...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'?
 
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.
 
=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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count Unique Values 17
Counting Unique entry from Concatenated list 24
Count Unique Values in a column, with critera, exclude empty cells 11
counting unique values of text 4
Conditional count of unique values 5
Count of unique filtered values 1
Counting Unique Values by Date Range 6
Count if ? formula needed! 3

Back
Top