Find a String

  • Hi All,

    I have a sheet with over 600 rows in Column A. What Im trying to do is to see if a particular set of 20 characters from Column A are also in Column BI.

    I have come up with the following code but unfortunately it doesnt work.

    All help greatly appreciated


  • Re: Find a String

    Thanks for the suggestion, unfortunately there are a few more tasks to be performed after the cell is filled with a "Confirm" value so Conditional Formatting wont solve this one.

    Thanks again for the suggestion though.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!