Results 1 to 7 of 7

Counting occurences of a string

Threaded View

  1. #1
    Registered User
    Join Date
    05-13-2010
    Location
    Earth
    MS-Off Ver
    Excel 2003
    Posts
    6

    Counting occurences of a string

    Hey Guys,

    I tried using counif statement, but that doesn look like it will work.

    What I have is a column with multiple pieces of data and I would like to account for the occurences a certain string appears in the column

    A
    1) 11
    13
    13.1
    12
    ------------------
    2) 13

    So my primary goal would be for the example above is to count all the occurences of just "13"(not 13.1) in column A

    My secondary would be able to use a cell reference in all of this, ie find all occurences of B1

    I look forward to suggestions
    Last edited by Garage23; 07-19-2010 at 04:46 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