If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sorting several columns
Hi,
I'm trying to sort a sheet, sorting first by column A, then B, then C It works fine half of the sheet, but then column C isn't sorted correctly. Data format is the same, so that's not the problem. In column C sorting I've made my own list to sort by (st, 1, 2, 3, 4), and it works fine the first 20 rows. Then it only sorts correctly in column A and B example A B C AA 1A st AA 1A 1 AA 2A AB 1A 1 AB 1A 5 AB 1A AB 1A st AB isn't sorted correctly according to the list I've made in the sorting box. Any ideas as to why, all cells have the same data format, and I've tried different ones. LTJ |
#2
|
|||
|
|||
Sorting several columns
Take a look for blank characters padding the values in columns A or B.
'AB' is different from 'AB '. The padded value will sort to the end. -- HTH... Jim Thomlinson "LTJ" wrote: Hi, I'm trying to sort a sheet, sorting first by column A, then B, then C It works fine half of the sheet, but then column C isn't sorted correctly. Data format is the same, so that's not the problem. In column C sorting I've made my own list to sort by (st, 1, 2, 3, 4), and it works fine the first 20 rows. Then it only sorts correctly in column A and B example A B C AA 1A st AA 1A 1 AA 2A AB 1A 1 AB 1A 5 AB 1A AB 1A st AB isn't sorted correctly according to the list I've made in the sorting box. Any ideas as to why, all cells have the same data format, and I've tried different ones. LTJ |
Thread Tools | |
Display Modes | |
|
|