|
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'? |
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'? |
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'? |
| All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com