Archive for April, 2012

Excel function to calculate numerology number

Function below to calculate the numerology number (reduced to 2 digits) for a name in Excel:

=SUM( 1* CHOOSE( CODE( MID( LOWER(A1); ROW( INDIRECT("1:" & LEN(LOWER(A1)))); 1))-96; 1; 2; 3; 4; 5; 6; 7; 8; 9; 1; 2; 3; 4; 5; 6; 7; 8; 9; 1; 2; 3; 4; 5; 6; 7; 8))

Press Ctrl+Shift+Return to have Excel treat it as an array function (it will enclose it in curly braces { and }).  A1 is the cell reference containing the name.

6 Comments

css.php