Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count If Like (Excel 2003)

    I need to count cells that contain the word exceeds. The problem is the a normal cell contains something like, 3.093 exceeds published precision.

    I would like to used a built in formula and not a macro.

    Thanks

  2. #2
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count If Like (Excel 2003)

    Figured it out

    =countif(A1:A10,"*exceeds*")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •