+ Reply to Thread
Results 1 to 2 of 2

VBA to find Muliple criteria

  1. 05-13-2009, 01:22 PM #1
    Anil2007
    Anil2007 is offline
    Registered User
    Join Date
    11-27-2008
    Location
    Noida
    Posts
    51

    VBA to find Muliple criteria

    Hi

    I need a help on the attch sample file,
    Is that possible that macro will search the column A, for all the Text
    Written in cell B1,C1,D1,Where ever in column A the cell value of B1,C1,D1
    find the macro print 1
    Attached Files Attached Files
    Last edited by Anil2007; 05-14-2009 at 11:37 PM.
    Reply With QuoteRegister To Reply
  2. 05-13-2009, 02:36 PM #2
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: VBA to find Muliple criteria

    I think you could use this formula:

    =IF(ISNUMBER(SEARCH(B$1,$A2)),1,"")
    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