| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| Convert Word Table to Excel Spreadsheet | Excel Discussion (Misc queries) | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
| How to convert the table in word to excel sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
