| 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 | |||
![Averitt Engineer[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
