Results 1 to 14 of 14

Excel 2007 : Constructing a formula that counts distinct words in a single cell

Threaded View

  1. #5
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Constructing a formula that counts distinct words in a single cell

    If you only have single digits as per your example then this formula will count them

    =COUNT(FIND({1,2,3,4,5,6,7,8,9,0},A1))
    Indeed, a better alternative

    I guess if you have 2 or 3 digit numbers too.. then you can use:

    =COUNT(FIND(ROW(INDIRECT({"1:1000"}))-1,A1))

    confimed with CTRL+SHIFT+ENTER...

    Change 1000 if larger than 3-digit numbers can be found
    Last edited by NBVC; 01-20-2010 at 04:03 PM.

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1