Counting words

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I have a column with different words for a budget like car, tv, etc.
There are a lot of them and in some cases there are repeats.
Is there any way to count the number of unique words, without counting
repeated words?

Thanks a lot for you help.
 
Hi
use
=SUMPRODUCT((A1:A20<>"")/(COUNTIF(A1:A20,A1:A20)+(A1:A20= "")))
 
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

The death of music TV channels in UK - but not Europe? 4
Office 365 Word - word count 1
Data Lookup Question 1
count unique entries 5
description of count in subtotal 1
Count only once 3
Count unique numbers 8
counting number of word in a cell 4

Back
Top