Bible book order sorting possible?

Discussion in 'Computers & Website Forum' started by Joseph M. Smith, Nov 18, 2010.

  1. Joseph M. Smith

    Joseph M. Smith
    Expand Collapse
    New Member

    Joined:
    Jan 27, 2006
    Messages:
    1,041
    Likes Received:
    0
    I have created a database of all my sermons, over the years, and the fields include not only the titles and the date preached, but also the principal Scripture references. It's done in Excel and so of course I can sort by title alphabetically and by date. Does anyone know of an add-on that might permit sorting the Scripture references in Bible book order? Of course I can sort alphabetically, but I would love to be able to do a Bible book order sort.
     
  2. matt wade

    matt wade
    Expand Collapse
    Well-Known Member

    Joined:
    Jan 6, 2009
    Messages:
    6,156
    Likes Received:
    76
    In Excel, when you click sort, you can choose the "Order". Choose "Custom List". You'll have to create the custom list, but then you can sort by anything you want.
     
  3. Don

    Don
    Expand Collapse
    Well-Known Member

    Joined:
    Oct 7, 2000
    Messages:
    10,550
    Likes Received:
    213
    Are you talking about ordering them by how the books are ordered in the Bible? (i.e., Genesis, Exodus, Leviticus, et al)

    If so, Matt's answer is probably best. Will only take a few minutes to set up the custom list.
     
  4. SBCPreacher

    SBCPreacher
    Expand Collapse
    Active Member

    Joined:
    May 30, 2006
    Messages:
    2,764
    Likes Received:
    0
    I wondered this same thing myself - thanks for the answer.
     
  5. Joseph M. Smith

    Joseph M. Smith
    Expand Collapse
    New Member

    Joined:
    Jan 27, 2006
    Messages:
    1,041
    Likes Received:
    0
    Thanks. There are more mysteries in Excel than this world dreams of!

    Back to database building ...
     

Share This Page

Loading...