Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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'? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique values, if ...
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. "Averitt Engineer" wrote: 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'? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count unique values, if ...
=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:T65 536),,FALSE) don't work either. any suggestions? "Joel" wrote: 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. "Averitt Engineer" wrote: 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'? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values | Excel Worksheet Functions | |||
Unique Count when Values 0.01 | Excel Worksheet Functions | |||
How to count unique values? | Excel Worksheet Functions | |||
Count of Unique values | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions |