Results 1 to 10 of 10

count the same values

Threaded View

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    NL
    MS-Off Ver
    Excel 2016
    Posts
    74

    count the same values

    Hello,

    I.ve got a small problem, maybe someone can help.

    In a column i've got the values shown beneath.
    Col AM
    ROW 1 xxxxxxxcxxcxccxcccxxxxxxx
    ROW 2 xcccccxccccxccccxcxcccccx
    ROW 3 xcxxxcxcxxccxcxxccxcxxxcx

    I''m looking for a formula that counts the value "x"until the value "c".

    So,
    A1, counts the first set of "x" .
    B1, counts the second set of "x"
    C1, 3th set of "x"
    this would be repeated with max 10 colums

    The outcome will be something like this:

    Column A B C D E F G H
    ROW 1 ) 7 2 1 1 7
    ROW 2 ) 1 1 1 1 1 1
    ROW 3 ) 3 1 2 1 2 1 3 1


    Anyone an idea?

    Thanks in advance.

    ABBOV
    Attached Files Attached Files
    Last edited by ABBOV; 09-09-2010 at 04:38 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