+ Reply to Thread
Results 1 to 2 of 2

Increment Cell Count If Column Contains "String"

  1. #1
    Registered User
    Join Date
    06-01-2010
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2003
    Posts
    11

    Increment Cell Count If Column Contains "String"

    Hi all,

    I'm sure it's possible but I can't work it out...

    Prepare for some really crappy pseudo code:

    If A:A (Whole column) contains "String"
    B1++

    So say Column A has "abc" in it 5 times, cell B1 will display 5.

    Please help it's doing my head in

    Thanks
    Last edited by Barrelroll; 06-01-2010 at 11:45 PM.

  2. #2
    Registered User
    Join Date
    06-01-2010
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Increment Cell Count If Column Contains "String"

    Disregard... I found something called countif... lol

+ 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