Results 1 to 5 of 5

Formula or Macro, match string,from 1 cell to a column,String use dash

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-21-2012
    Location
    miami, florida usa
    MS-Off Ver
    Excel 2007
    Posts
    260

    Formula or Macro, match string,from 1 cell to a column,String use dash

    Hi,

    I know how to create a some Formulas and simple macro, but i need some help

    on this Issue

    If 2 or 3 (dynamically) Numbers from Cell Z8 Match any combination/Row
    of Column G12 (down), then i need to noticed wherever i copy the Formula
    (it can be column E12 to E1000)
    of course, that i need to exclude these combination matched with min string, but then this post
    it get complex (may be a macro?)

    What i'm Adding:
    ============
    CELL Z8
    I need to Use In a single Cell Z8 to hold over 22 Numbers, with leading zero and with dash "-"
    like : 01-02-03-04-05-06....

    What already have
    ==============
    COLUMN G12 to G1000
    The sheet already have a Single Column that hold combinations with
    Groups combination between 4 to 13 Numbers
    and it already use the same Format (leading zero and with dash "-")

    to make this formula is hard for me, because i ever work with :
    a-.Combinations in Single Cell
    b-.Combination comes with dash "-",
    c-.Combination Numbers are with 2 Digits, example : 01-02-03, etc,etc..


    Please, please.... :-(

    Thank you so much!


    Best Regards

    David
    Attached Files Attached Files
    Last edited by david gonzalez; 12-07-2013 at 02:16 PM. Reason: After 3 days. no response, already ask to forum moderator, mr alansidman

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find and highlight cells in workbook that is NOT an exact match to the cell content
    By AndyHowcroft in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-30-2013, 12:05 AM
  2. Macro To find match Value from other clomn and highlight in yellow
    By tariqnaz2005 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2012, 09:42 AM
  3. Find and Search Workbook based on Cell Range
    By arihant.jain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2012, 12:28 AM
  4. How to find match data and exclude with condition
    By buvan in forum Excel General
    Replies: 2
    Last Post: 11-17-2011, 06:51 AM
  5. Exclude From MATCH Search
    By ntesla123 in forum Excel General
    Replies: 1
    Last Post: 10-22-2010, 06:45 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