Posted to microsoft.public.excel.worksheet.functions

Averitt Engineer[_2_] Averitt Engineer[_2_] is offline

external usenet poster

Posts: 7

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count Unique Values	Dave	Excel Worksheet Functions	5	December 4th 08 10:20 PM
Unique Count when Values 0.01	Jill1	Excel Worksheet Functions	3	November 22nd 06 01:36 PM
How to count unique values?	Annie	Excel Worksheet Functions	0	March 3rd 06 07:17 PM
Count of Unique values	Richard	Excel Worksheet Functions	3	September 27th 05 05:46 AM
Count unique values and create list based on these values	vipa2000	Excel Worksheet Functions	7	August 5th 05 01:17 AM

All times are GMT +1. The time now is 07:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us