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
    Banned User!
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    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,866

    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)

Similar Threads

  1. [SOLVED] Search in a 6x6 using first two characters by comparing to first two characters in column
    By bcas77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2018, 10:30 AM
  2. Comparing two cells and returning not matching characters
    By sathishkm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2017, 10:05 AM
  3. Match comparing characters not the cell value
    By ABBOV in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-02-2015, 10:41 AM
  4. [SOLVED] Search/return a cell with a large number of characters from a list (column)
    By jwebber82 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-30-2014, 09:44 PM
  5. [SOLVED] Search column for location of characters/numbers in cells with different digit lengths
    By nbhowe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2013, 05:38 PM
  6. Comparing characters
    By GaidenFocus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-29-2013, 12:30 PM
  7. Replies: 11
    Last Post: 01-23-2013, 02:04 PM

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