+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : Count Occurrences of Text in Data Range

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    4

    Count Occurrences of Text in Data Range

    I don't know how to explain this the best, so I took a random screenshot to show it

    The data list would be unpredictable and would vary, so I am thinking that I would have to build an array with the data in the datalist, and run a loop, etc

    Ideally, it would generate the "Count Occurrences" table on a new sheet

    I have attached an image to show what I am trying to do

    As of now, I am taking a report from a program, copying the results into a table into Access, running a Duplicate query, copying those results back over to Excel and sorting the results in descending order.

    Any help or pointers appreciated,

    Thanks!

    Edit: to add, I have limited Excel/Access usage (learned it back in Office 2000 and am being reintroduced, but used to also code in Visual Basic 3,4, and 5 when I was a kid). Therefore, I have some technical aptitude, but am just very rusty at the moment and having a hard time putting this all together.
    Attached Images Attached Images
    Last edited by gtlandis; 09-20-2011 at 02:15 PM.

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Count Occurrences of Text in Data Range

    I wasn't sure if you meant count characters, but here is an attempt at what you want.

    attached is a test workbook, you can fill it with data in the A column....the macro will then count the occurences of all the characters and present a report of that information in a new tab.

    Please Login or Register  to view this content.

  3. #3
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: Count Occurrences of Text in Data Range

    sorry, still new forgot the attachment, here it is
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-20-2011
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Count Occurrences of Text in Data Range

    Thanks for the response. Perhaps my screenshot or example was a little misleading. The data list would contain text strings. Therefore, it could be a single character, a single word, or a series of words in each cell.

  5. #5
    Registered User
    Join Date
    09-20-2011
    Location
    Indiana
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Count Occurrences of Text in Data Range

    Anyone else?

  6. #6
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Count Occurrences of Text in Data Range

    It needs further explanation.

    Upload a sample excel workbook with correct sample data and your desired results

    In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

+ 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