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
Bookmarks