Jump to content

Please read the Forum Rules before posting.


Sorting Scripture references in Excel

  • Please log in to reply
11 replies to this topic

#11 JimSussex


    New to Bible Support

  • Members
  • Pip
  • 1 posts

Posted 01 September 2017 - 06:56 AM

You can sort in bible book order using the VLOOKUP function in Excel. Create a table  with a column of numbers 1 through 66. In the column to the right list the books of the Bible in order. So now each book is assigned it's number.  This is the lookup table. 

Add the table into the worksheet that you want to sort.  Now in the first cell of the column immediately to the left of the column with the unsorted book names insert the formula  =VLOOKUP(C1,$A$104:$B$169,2,FALSE), where in this example C1 is the first cell to the right of the formula with the out of order book name. the $A$104:$B$169 is the location of the table,  the "2" is the column in the table that has the corresponding book number( i.e. Genesis is #1 Revelation is #66), the FALSE argument is needed so excel will look at each cell in the way needed.

Now fill down the column so the formula is in each cell if the column. Then do a copy /paste to replace the formulas with their actual values.

You can now remove the table and format the worksheet to sort.

#12 BH.


    Utility Developer

  • Contributors
  • PipPipPipPipPip
  • 1,131 posts
  • LocationCalifornia

Posted 01 September 2017 - 07:43 PM

Image already added

Both e-Sword TooltipTool NT and e-Sword HotKey have scripture sorting functions for scripture lists.  It is not excel. 

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Similar Topics

Latest Blogs