distinct count of text in different wb?

[Dan-X !]

How do you do a distinct count of text in another workbook? I've
seached online and have found several formulas but can't get any to
work right.

This is the formula I last tried...

=SUMPRODUCT((Queue_User_Routing.csv,$B$2:$B$2000<>"")/COUNTIF(Queue_User_Routing.csv!$B$2:$B$2000,$B$2:$B$2000))

Any suggestions?

Thanks!!!
-Danny

 

[Dave Peterson]

This is the formula syntax that I'd use:

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))


=SUMPRODUCT((Queue_User_Routing.csv!$B$2:$B$2000<>"")
/COUNTIF(Queue_User_Routing.csv!$B$2:$B$2000,
Queue_User_Routing.csv!$B$2:$B$2000&""))

If your worksheet has been renamed to something else, you may want to let excel
build the formula by pointing and clicking on the ranges.

 

[Dan-X !]

Dave...

The formula worked great! Thank you very much!!!

-Danny