I am doing a research project on the scriptures that involves me listing certain verses with their chapter numbers. My idea is to make one column where each verse and chapter I am referencing will be in this format ---> For example: chapter 5 verse 2 = 5.2. I formatted all cells in my column as 'numbers' and then under the ribbon tab 'data' I pressed sort A-Z, but it doesn't want to numerically from smallest to greatest organize the numbers (and I need to, since all 1000 something verses are not in the slightest bit arranged that way). I was thinking about separating it into two separate columns - a chapter column and a neighboring verse column, but then that would mean that when I sort it'll just put all the 5 verses together without dragging the ones with the same chapter number along. Anybody know what I could do to make it sort out from smallest chapter and verse number to largest chapter and verse number? (For example: from 1.1. to 100.14.)
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sorting Data
- Thread starter dvstdvst
- Start date
RickXL
MrExcel MVP
- Joined
- Sep 9, 2013
- Messages
- 4,328
Hi and welcome to the MrExcel Message Board.
If it were me I would have separate columns for chapters and verses. You can then sort on both columns to get things into order using a Custom sort.
An option would be to join the numbers together and pad them out with zeros. For instance if you never needed more than 99 chapters and verses you could start from CH1 v 1 with 01.01 then go through 01.02, 01.03 etc. You could use the format 00.00 to achieve that or you could enter the data as text.
If it were me I would have separate columns for chapters and verses. You can then sort on both columns to get things into order using a Custom sort.
An option would be to join the numbers together and pad them out with zeros. For instance if you never needed more than 99 chapters and verses you could start from CH1 v 1 with 01.01 then go through 01.02, 01.03 etc. You could use the format 00.00 to achieve that or you could enter the data as text.
Upvote
0
