Results 1 to 4 of 4

Multiple contains function

Threaded View

  1. #1
    Registered User
    Join Date
    10-02-2012
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    4

    Multiple contains function

    I am trying to do a if or statement with a multiple countif statement and im not sure if what I want to do is possible.
    I have a comments column of text and I only want to pull out the text with certain key words. This is my formula at the moment =IF(OR(COUNTIF(B6,"*period*"),B6="*location*"),"true","false").
    Please can some advise if there is any kind of solution to this. Many thanks
    Last edited by oldskool; 10-02-2012 at 11:58 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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