+ Reply to Thread
Results 1 to 2 of 2

Excell: count occurance of letters in a column

  1. #1
    Ispencer
    Guest

    Excell: count occurance of letters in a column

    I would like to have Excell count an occurance of letters in a column, like
    subtotal only without splitting the data, simply give a total of occurances
    of a letter in the column. Can this be done?

  2. #2
    Ron de Bruin
    Guest

    Re: Excell: count occurance of letters in a column

    Yes this is possible

    Use this array formula, use CTRL-SHIFT-ENTER instead of ENTER for the letter a

    =SUM(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"a","")))

    More info about them you can find here
    http://www.cpearson.com/excel/array.htm



    --
    Regards Ron de Bruin
    http://www.rondebruin.nl


    "Ispencer" <[email protected]> wrote in message news:[email protected]...
    >I would like to have Excell count an occurance of letters in a column, like
    > subtotal only without splitting the data, simply give a total of occurances
    > of a letter in the column. Can this be done?




+ Reply to Thread

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