Results 1 to 44 of 44

Concatenate VARIABLE ranges of Character Strings

Threaded View

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    59

    Unhappy Concatenate VARIABLE ranges of Character Strings

    See attached for a better context of what I'm getting at.

    Please have forgiveness if this sounds familiar. I should say I DID NOT write this formula.

    I have a Formula that recognizes the pattern of values (characters) in the range specified. I am wanting to create a Character string that will show the pattern of values (see UNIQUE field). The Formula does what I need it to do, but the one problem I have is that if the template type string?! in the formula (for lack of a better word) changes to 8 or 4 cells, as in ("00000000") or ("0000"), the results down below on the page don't change. For example, if one range is "000000" and the next range is "00000000" the next value in UNIQUE will only be "000000"....the 4th record in the series won't show up.

    I have to manually change the number of cell references in the Formula as well as the number of 0s in the template type string to get the correct values in the UNIQUE field.

    What I want to know is how can I get the formula to be Dynamic enough to recognize variable cell ranges?

    Thanks for your forgiveness.

    Dan
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert ASCII Character strings into HEX Strings
    By Chris Mathers in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-13-2010, 12:25 PM
  2. matching character strings
    By andymac63 in forum Excel General
    Replies: 2
    Last Post: 04-16-2007, 04:29 PM
  3. Character Locations in Strings
    By Pflugs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-07-2006, 07:30 PM
  4. [SOLVED] Counting variable ranges and auto-summing variable ranges
    By Father Guido in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2006, 11:10 PM
  5. [SOLVED] concatenate strings
    By Gary''s Student in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-15-2005, 01:05 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