Closed Thread
Results 1 to 3 of 3

Search in a 6x6 using first two characters by comparing to first two characters in column

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    90

    Search in a 6x6 using first two characters by comparing to first two characters in column

    So I'm trying to use a find function to look at the first cell that meets a condition in a column (F2:F25) (I've got that part locked in, I have the correct ActiveCell selected in my formula) then try to find a cell in a 6x6 range that initially will match but will be modified over time. The first two characters in the 6x6 (X1:AC6) will always stay the same, however, and no other cell in that range will have identical first two characters. On a match it needs to change its cell color to blue, which I've got locked in as well. Just having difficulty with the find portion. I thought using either like or instr would work but haven't had any luck so far.

    Is there a good way to do this?
    Please add *rep if I helped you!

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,187

    Re: Search in a 6x6 using first two characters by comparing to first two characters in col

    Looks like your thread has duplicated in error, I've flagged this one to mods for locking to avoid confuision.

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,836

    Re: Search in a 6x6 using first two characters by comparing to first two characters in col

    Duplicated here : https://www.excelforum.com/excel-pro...in-column.html

    Thread Closed.
    Please familiarise yourself with the rules before posting. You can find them here.

Closed 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1