+ Reply to Thread
Results 1 to 5 of 5

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) 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 Contributor
    Join Date
    05-12-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    266

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

    Show us what you've locked in an example file

  3. #3
    Forum Expert
    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

    Will be along the lines of

    Please Login or Register  to view this content.
    Note that there is an undefined varaible of x which should refer to the original string for comparing, if I follow your description correcty, this would be the result of the Find function in F2:F25.

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

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

    Below is the Macro I'm using

    Please Login or Register  to view this content.
    Attached Files Attached Files

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

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

    Looks like that works perfectly, thanks a bunch!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. 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
  2. VBA Characters() Function Fails when the Cell Content Exceeds 261 Characters
    By :) Sixthsense :) in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-07-2016, 06:37 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

Tags for this Thread

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