You have two other solutions posted and, quite frankly, I don't think they
do what you want. But quite frankly, I am not so sure my solution below does
what you want either. If it turns out that none of our attempted solutions
do what you want, you will have to provide more information... it would be
helpful if you gave an actual example (or even several examples) of what you
have in your cells, where you want the formula (or formulas) to be placed at
AND what you expect the formula(s) to display.
My attempted solution
=======================
With a letter of the alphabet in some cell, put this formula in the cell
directly under it...
=CHOOSE(CODE(UPPER(OFFSET(INDIRECT(ADDRESS(ROW(),COLUMN())),-1,0)))-64,9,12,3,etc)
where the "etc" in the formula above is the rest of the (comma separated)
values for each letter in the alphabet. That means, for the above values, a
9 will be displayed if the cell above it has an "A" in it, a 12 will be
displayed if the cell above it has a "B" in it, a 3 will be displayed if the
cell above it has a "C" in it, and so on for the rest of the alphabet.
Rick
