Do you base that sum on the original value (ABC) or do you have a table that
shows the numeric equivalent for ABA, BCA, CAB, etc?
Pookie76 wrote:
>
> Dave Peterson Wrote:
> > If you don't get a helpful reply, you may want to describe what you're
> > trying to
> > do.
> >
> > Maybe some examples of what you start with and what you should end
> > with.
> >
> > And what function you're using--you posted two functions.
> >
> >
>
> The first function coverts a 1 letter code to a 3 letter code. The
> second function coverts the 3 letter code into a sum of numerical
> values.
> Ie.
> If you type in: ABC in A1. A2 results in Aba-Bca-Cab. A3 results in a
> sum of the 3 letter codes. (Aba=1, Bca=2, Cab=3) so A3's value becomes
> 6.
>
> Thanks.
>
> --
> Pookie76
> ------------------------------------------------------------------------
> Pookie76's Profile: http://www.excelforum.com/member.php...o&userid=12815
> View this thread: http://www.excelforum.com/showthread...hreadid=469014
--
Dave Peterson
Bookmarks