I think you will need to return something like a string or array of values
indicating whether each char in the second string is :
1-Right-char, right location
2-Right-char, wrong location
3-Wrong-char
4-Position does not exist in first string
What would you expect from
BB26 BBBB26
You need to define more clearly the rules of comparison required.
NickHK
"Odin" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi NickHK/JLGWhiz,
>
> I hope that this example will enable you to understand the problem
> better.
>
> B C D E
> 1 RX5TGE RX5TGEU U 7
> 2 I3816AE 13816AE 1 1
> 3 A269LYT B269LYT M 1
> 4 LGP5XGB LGR5ZGB RZ 35
> 5 BB26 BBZ526 Z5 34
> 6 BBZ526 BB26 This does not ocur
>
> Thanks again for the consideration.
>
>
> NickHK wrote:
> > The return value would depend on whether you are basing it on the 1st or
> > second string.
> > What value would you expect for "BBZ526" and "BB26" then ?
> >
> > You could maybe use some "padding" character in the return string, so it
is
> > as long as the longer string.
> >
> > NickHK
> >
> > "Odin" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > Hi NickHK, the compared strings could be of different lengths. As i
> > > already have columns with the string lengths, in your example I would
> > > expect D2 to still return "Z5" in positions "34".
> > >
> > > The binary string solution to cell E2 is interesting but in your
> > > example would that return "110011" or just "1100"?
> > >
> > > Odin
> > >
> > > NickHK wrote:
> > > > Are all the compared strings the same lengths ?
> > > > If not, what would you expect from "BB26" and "BBZ526" ?
> > > >
> > > > How about if you just returned a binary string, representing each
> > character
> > > > ?
> > > > e.g. "BB26" and "BBZ5" returns "1100"
> > > > But this depend somewhat on your answer to the first question.
> > > >
> > > > NickHK
> > > >
> > > > "Odin" <(E-Mail Removed)> wrote in message
> > > > news:(E-Mail Removed)...
> > > > > Hi All,
> > > > >
> > > > > I have asked here before and on other fora for help on the
following
> > > > > problem ( i am a total novice at VB and Macros):
> > > > >
> > > > > I have a large excel spreadsheet with alpha-numeric data. I want
to be
> > > > > able to compare two cells in the same row and return the disimilar
> > > > > characters in another cell(s).
> > > > >
> > > > > e.g. I have in cell B2, "BB26" and in cell C2, "BBZ5". I need to
> > > > > compare the cell C2 to cell B2 and return the disimilar characters
in
> > > > > cell D2 which in this case would be the characters "Z5".
> > > > >
> > > > > If possible i would like to specify in cell E2 the positions of
the
> > > > > differing characters i.e. cell E2, "34" representing the 3rd and
4th
> > > > > positions of the disimilar characters.
> > > > >
> > > > > If there is a better and more elegant solution to this problem
that
> > > > > would provide a similar solution, i would appreciate your help
very
> > > > > much.
> > > > >
> > > > > Thank you in advance.
> > > > >
> > >
>
|
Similar Threads
