Archive for April, 2012
Excel function to calculate numerology number
Posted by Bricky in Programming on April 29, 2012
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.