Name number program
excellent work.
THanks a ton
"Rick Rothstein" wrote:
=SUMPRODUCT(INT((FIND(MID(UPPER(A1),ROW($1:$999),1 ),
" AIJQYBKR CGLS DMT EHNX UVW FP OZ")-1)/5))
By the way... don't modify the spacing in any way... I know it looks funny,
but the exact spacing I have used is critical to the proper functioning of
the formula.
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Assuming Indian Numerology, the 'D' located in the "2" group is supposed
to be a 'B'. This formula will produce the sum you want (it treats upper
and lower case letters the same)...
=SUMPRODUCT(INT((FIND(MID(UPPER(A1),ROW($1:$999),1 ),
" AIJQYBKR CGLS DMT EHNX UVW FP OZ")-1)/5))
--
Rick (MVP - Excel)
"Venkatesh V" wrote in message
...
HI,
I require a macro / program or excel based tool -- which gives the total
number based on the numbers assigned to each letter.
here are the number assignation to letters.
AIJQY = 1
DKR = 2
CGLS = 3
DMT = 4
EHNX = 5
UVW = 6
FP = 7
OZ = 8
My requirement is -- i have some 50 names.
copy all the names in a column, run macro or function that will
automatically populate the sum of numbers in each letter of the names (in
next column)
i have tried it. but its geting difficult and time consuming. errors are
creeping up for this simpe program!
For example names could be
A Varsha
G Sanya
V Viveka
..
..
so, could you please provide that program.
Thanks & Regards,
Venkatesh
|