Results 1 to 21 of 21

Add an 'x' to column U if

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2011
    Location
    UK
    MS-Off Ver
    2016
    Posts
    45

    Add an 'x' to column U if

    Hello,

    After a fair bit of searching i'm unable to find / alter a suitable macro.

    Aim:
    - Look at A2:O2 and if 'this word or words' AND 'this word or words' appear in any cell then add an 'x' to U2.

    Misc:
    - spread sheet has thousands of rows
    - there will be a number of terms to search for. Such as ('hello' AND 'goodbye', 'red' AND 'blue, 'blue' AND 'water')

    Would much prefer a macro as there are already a number of formulas involved.

    Many thanks in advance
    Last edited by Greenal; 09-29-2011 at 07:12 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