Results 1 to 3 of 3

Excel 2007 : Count no. of cells Starting with a particular value within a column

Threaded View

  1. #1
    Forum Contributor SCLai's Avatar
    Join Date
    08-18-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    129

    Count no. of cells Starting with a particular value within a column

    Hi everyone, I have another question...

    How can I get the number of cells that start with a particular value in a column?
    e.g "ST"

    -------A
    1 ST1253
    2 SVST5
    3 5012-2
    4 5003-2
    5 A1G03
    6 A1G04
    7 ST9013

    The value will be "2"... but how can I do it via formula?

    Thanks!
    SC
    Last edited by SCLai; 09-13-2010 at 12:47 AM.

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