numerology chart1

1. numerology chart1

i want to create a spreadsheet for calculating numerology numbers.
i used to be able to do this quite easily in the old LOTUS 123
but now cannot figure out how to do in excel

would enter letters of name each in its own cell
then relate each letter to a number......

if letter a,j or s in cell 1, then value is 1 else blank
if letter b,k, or t in cell 2, then value is 2 else blank
if letter c,l, or u in cell 3, then value is 3

if i can get these to work i can figure out rest of alphabet

hope someone could help.
thanks

2. Re: numerology chart1

Do you remember how you did it in Lotus? From what I have seen, though there are a few differences from spreadsheet application to spreadsheet application, for the most part, all spreadsheets have used the same core of functions. Likely, the functions you used for this in Lotus (such as VLOOKUP() or SUM(), etc.) are present in Excel as well.

3. Re: numerology chart1

aahh good ol 123, I migrated to that after I cut my teeth on SuperCalc

Not sure if you can adapt the blow to what you are trying to do...
 A B C D E F 1 a b c d e 15 2 3 1 2 3 4 5 4 97 98 99 100 101

Rows 3 and 4 are just to show how it works, and to test, and are not needed
A3=CODE(LOWER(A1))-96
A4=CODE(LOWER(A1))

The actual calc is in F1...
F1=SUMPRODUCT((CODE(LOWER(A1:E1))))-(COUNTA(A1:E1)*96)

4. Re: numerology chart1

http://www.excelforum.com/excel-form...gy-chart2.html

If these are NOT the same, please let me know. I am closing the other thread, so you can continue here. If they are different, send me a PM detailing how they differ, and I will reopen the other 1

5. Re: numerology chart1

Fdibbins....
I posted two charts.
Chart1 was asking for formula to apply numbers to letters
Chart2 was asking how to determine only the vowels and consonants in each name
And then apply numbers

Re: your sample. Not clear to me, will work on it to see I can figure it out.

MRshorty...
Ooh migrated from lotus many many years ago and do not remember much of what I did then. Did not do such complex formulas in that day.

6. Re: numerology chart1

Ford,
I culd have sworn that I enervated two different requests one titled chart 1
And other chart2.

I culd not get to view chart2 to check if I was correct.

Will wait to see if I am successful with chart 1 request and then will re submit request for chart 2
Thnx

7. Re: numerology chart1

See the attachment

8. Re: numerology chart1

I look on your post chart2, and here the solution for both post chart1 and char2

9. Re: numerology chart1

see the attached file
created a table with alphabets, alphabet type and number
you can modify the table as per requirement

10. Re: numerology chart1

Am not getting this yet... Feel little dumb at this point! Tho once I get it, I will be on my way.
Mayb not explaining myself well.
I will create an example excel sheet and explain what I am trying to do.
Then will use advanced option and attach.
Need to work on that yet. Be back later!
Thnx

11. Re: numerology chart1

thank you all for your help!!
I am not very good at fully understanding the examples you have so kindly provided.

attached is a file which I hope will explain what i am trying to do.

all i would like is the forumula
example:

IF letter in one cell matches letter in column of table enter number at top
and so on until full name is complete

then
IF letter in one cell is vowel, a e i o u y
enter number at top of table

then
IF letter in once cell is consonant, alphabet minus vowels
enter number at top of table

I hope this is help you get a feel for what i want to do.
as you can see, it can be done manually
but would be so much easier to do via excel....if possible.

thanks

12. Re: numerology chart1

see the attached file

13. Re: numerology chart1

that is wonderful table....
however, what i am looking for is the actual formula to get those results.

oops...did a right click on cell and saw formula.
thanks so much.
will work on it in my excel sheet and hopefully i can get it working.

14. Re: numerology chart1

Wow incredible job ! Thank you very much, I was trying to do this as simple and efficient but without any success ! I will take your file as reference

15. Re: numerology chart1

Hello there,

In numerology you need to count vowels and consonants apart. I have used and modified a formula provided by Vijay on a site you can google (this forum doesn't allow posting links to new users).

Also some schools count Y as consonant, so there is an option for that too in the spreadsheet.

There are two spreadsheets inside, in the second one you can highlight any number you need.

Have fun.

16. Re: numerology chart1

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1