+ Reply to Thread
Results 1 to 3 of 3

Counting number of times a Text pattern appeared in a range

Hybrid View

  1. 02-13-2008, 03:50 AM #1
    khalidawan
    khalidawan is offline
    Registered User
    Join Date
    02-13-2008
    Posts
    4

    Cool Counting number of times a Text pattern appeared in a range

    Dear All,

    Hope all fine

    Suppose i have a range A1:A13 and it is filled with data. suppose the data is as below.

    Fun
    Funny
    Hunny
    Sunny
    Fun
    Funny
    Hunny
    Sunny
    Fun
    Funny


    Now i want to count number of times "un" appeared in this column A.

    how can i do it using excel formula ?
    Reply With QuoteRegister To Reply
  2. 02-13-2008, 04:09 AM #2
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    I'd use
    =COUNTIF(A1:A13,"*un*")
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
  3. 02-13-2008, 05:35 AM #3
    khalidawan
    khalidawan is offline
    Registered User
    Join Date
    02-13-2008
    Posts
    4

    Wink

    it was so simple,


    thanks any ways
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1