Count duplicates where the next column contains specific text

  • Thread starter Thread starter ar0618
  • Start date Start date
A

ar0618

I need to write a formula which counts the number of unique entries i
columnA where the corresponding entries in columnB contain a specifi
string of text (ie *text*).

Can anyone help with an answer to this problem or is it impossible t
do in excel
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count continuous duplicates 2
How to assign unique number to column duplicates? 3
Count Dates? 5
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
counting commas within a string 3
Counting unique cells (with text) in a filtered list 5
excluding column headers from formulas 3

Back
Top