Count number of different words in a list

**XOR LX** · 01-15-2015, 06:22 AM

If your version of Excel is using a language other than English, then you'll need to translate the formula accordingly.

For example, in Portuguese:

=SOMARPRODUTO(1/CONTAR.SE(D5:D36;D5:D36))

(And your end reference should be 36, not 37, otherwise you'll have a circular reference.)

Regards

**pedro90** · 01-15-2015, 06:26 AM

Hello XOR LX,

I tried this right now and unfortunately did not work as well

I really think that's something to do with the fact of the list is composed by words instead of number...but I don't know how to figger this out...

Count number of different words in a list

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Count number of different words in a list

Re: Count number of different words in a list

Thread Information

Users Browsing this Thread

Similar Threads

Makro/Formula to count number of consecutive particular words in a list of random words

[SOLVED] How to count the number of cells that contain a number of words?

[SOLVED] number count two different words

[SOLVED] How can we count the number of words in Excel

[SOLVED] How do I count the number of words in a cell?

Bookmarks

Bookmarks

Posting Permissions