distinct count of text in different wb?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan-X ! - 30 Aug 2006 03:30 GMT

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

Reply to this Message

Dave Peterson - 30 Aug 2006 03:51 GMT

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.

> 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
[quoted text clipped - 8 lines]
> Thanks!!!
> -Danny

Signature

Dave Peterson

Reply to this Message

Dan-X ! - 30 Aug 2006 18:01 GMT

Dave...

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

-Danny

Reply to this Message