Bible book order sorting possible?

[Joseph M. Smith]

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.

 

[matt wade]

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.

 

[Don]

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.

 

[SBCPreacher]

I wondered this same thing myself - thanks for the answer.

 

[Joseph M. Smith]

Thanks. There are more mysteries in Excel than this world dreams of!

Back to database building ...