+ Reply to Thread
Results 1 to 18 of 18

Count number of different words in a list

Hybrid View

  1. 01-15-2015, 08:01 AM #1
    XOR LX
    XOR LX is offline
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Count number of different words in a list

    Hmmm.

    Did you get a #NAME? error again? Maybe your language version is actually "Brazilian" Portuguese, not "Portuguese" Portuguese?

    Perhaps this works for you?

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

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/
    Reply With QuoteRegister To Reply
  2. 01-15-2015, 09:09 AM #2
    pedro90
    pedro90 is offline
    Registered User
    Join Date
    03-31-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: Count number of different words in a list

    It worked Thanks a lot
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Makro/Formula to count number of consecutive particular words in a list of random words
    By topkiwi1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-02-2014, 03:49 PM
  2. [SOLVED] How to count the number of cells that contain a number of words?
    By Michad95 in forum Excel General
    Replies: 4
    Last Post: 11-16-2013, 07:18 AM
  3. [SOLVED] number count two different words
    By m_789 in forum Excel General
    Replies: 3
    Last Post: 09-19-2013, 10:15 AM
  4. [SOLVED] How can we count the number of words in Excel
    By otterandrews in forum Excel General
    Replies: 7
    Last Post: 06-13-2012, 04:00 AM
  5. [SOLVED] How do I count the number of words in a cell?
    By Phil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-02-2006, 02:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1