+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 16

numerology chart1

  1. #1
    Registered User
    Join Date
    01-09-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    7

    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. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,368

    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.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,275

    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

    A1:E1 are your letters
    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)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,275

    Re: numerology chart1

    By the way, this thread looks pretty much the same as your other thread...
    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. #5
    Registered User
    Join Date
    01-09-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    7

    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.

    Thankyou for your help!

  6. #6
    Registered User
    Join Date
    01-09-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    7

    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. #7
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    563

    Re: numerology chart1

    See the attachment
    Attached Files Attached Files
    Click (*) if you received helpful response.

    Regards,
    David

  8. #8
    Valued Forum Contributor
    Join Date
    02-05-2013
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    563

    Re: numerology chart1

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

  9. #9
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,272

    Re: numerology chart1

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

    Say thanks to those who have helped you by clicking Add Reputation star.

  10. #10
    Registered User
    Join Date
    01-09-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    7

    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. #11
    Registered User
    Join Date
    01-09-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    7

    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
    Attached Images Attached Images

  12. #12
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    7,272

    Re: numerology chart1

    see the attached file
    Attached Files Attached Files

  13. #13
    Registered User
    Join Date
    01-09-2015
    Location
    canada
    MS-Off Ver
    2007
    Posts
    7

    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. #14
    Registered User
    Join Date
    05-01-2015
    Location
    Switzerland
    MS-Off Ver
    libreoffice 4.2
    Posts
    1

    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. #15
    Registered User
    Join Date
    10-06-2018
    Location
    World
    MS-Off Ver
    2010
    Posts
    2

    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.
    Attached Files Attached Files
    Last edited by RealSyco; 12-12-2018 at 02:21 PM.

+ Reply to Thread
Page 1 of 2 1 2 LastLast

Thread Information

Users Browsing this Thread

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

Bookmarks

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