Count duplicates where the next column contains specific text

=SUM(--(FREQUENCY(IF(B2:B100="text",MATCH(A2:A100,A2:A100,0)),ROW(INDIRECT("
1:"&ROWS(A2:A100))))>0))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ar0618" <[email protected]> wrote in
message news:[email protected]...
>
> I need to write a formula which counts the number of unique entries in
> columnA where the corresponding entries in columnB contain a specific
> string of text (ie *text*).
>
> Can anyone help with an answer to this problem or is it impossible to
> do in excel?
>
>
> --
> ar0618
>
>
> ------------------------------------------------------------------------
> ar0618's Profile:
http://www.excelforum.com/member.php...o&userid=31093
> View this thread: http://www.excelforum.com/showthread...hreadid=507620
>