ExcelBanter - count unique phrases in a word table or spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count unique phrases in a word table or spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/45592-count-unique-phrases-word-table-spreadsheet.html)

SDB

count unique phrases in a word table or spreadsheet

I need a macro or function to count the number of unique phrases in a word
table or spreadsheet. I have tried using several different COUNTIF functions
but I keep getting the same errors each time. Any suggestions?

Domenic

Assuming that Column A contains your data, try...

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

Adjust the range accordingly.

Hope this helps!

In article ,
SDB wrote:

I need a macro or function to count the number of unique phrases in a word
table or spreadsheet. I have tried using several different COUNTIF functions
but I keep getting the same errors each time. Any suggestions?

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