Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More columne sorting
I have a quite normal worksheet with 5-6 columns filled with text info
The cells are defined as text I like to sort the columnes by first col A and then by Col B. I am doing by the schoolbook (I think), meaning that I am using the data sort function, selecting first A then B. However B is sorted in a strange way, like in groups. Words starting with a in Col B, can show up in two groups, with other groups of letters in between. Any idea of what's wrong? BEO |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More columne sorting
BEOPS wrote:
I have a quite normal worksheet with 5-6 columns filled with text info The cells are defined as text I like to sort the columnes by first col A and then by Col B. I am doing by the schoolbook (I think), meaning that I am using the data sort function, selecting first A then B. However B is sorted in a strange way, like in groups. Words starting with a in Col B, can show up in two groups, with other groups of letters in between. Any idea of what's wrong? BEO There is nothing wrong; this is the way simultaneous sorting on multiple columns is supposed to work. It keeps the related data on the same row. Consider the following table showing employees and the the award(s) they received: A B Name Award Clive J Dana K Adam Z Adam K Now you want to sort, first by Name, then Award Code. The correct result is: Adam K Adam Z Clive J Dana K Notice how "K" appears at the top, then again at the bottom--the "problem" you described. Now what if each column was sorted independently: Adam J Adam K Clive K Dana Z But this is saying Adam received award "J" -- which is not true! Hope this helps! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More columne sorting
Sorry for beeing unclear. Relating to your exempel I get this kind of result
for one specific value in Col A Adam Ka Adam Ka Adam Kb Adam Kb Adam F Adam F Adam Ka Adam Ka Adam F Adam F This is what I mean with strange grouping and is not what I expect -- BEO "smartin" wrote: BEOPS wrote: I have a quite normal worksheet with 5-6 columns filled with text info The cells are defined as text I like to sort the columnes by first col A and then by Col B. I am doing by the schoolbook (I think), meaning that I am using the data sort function, selecting first A then B. However B is sorted in a strange way, like in groups. Words starting with a in Col B, can show up in two groups, with other groups of letters in between. Any idea of what's wrong? BEO There is nothing wrong; this is the way simultaneous sorting on multiple columns is supposed to work. It keeps the related data on the same row. Consider the following table showing employees and the the award(s) they received: A B Name Award Clive J Dana K Adam Z Adam K Now you want to sort, first by Name, then Award Code. The correct result is: Adam K Adam Z Clive J Dana K Notice how "K" appears at the top, then again at the bottom--the "problem" you described. Now what if each column was sorted independently: Adam J Adam K Clive K Dana Z But this is saying Adam received award "J" -- which is not true! Hope this helps! . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More columne sorting
-- BEO "smartin" wrote: BEOPS wrote: I have a quite normal worksheet with 5-6 columns filled with text info The cells are defined as text I like to sort the columnes by first col A and then by Col B. I am doing by the schoolbook (I think), meaning that I am using the data sort function, selecting first A then B. However B is sorted in a strange way, like in groups. Words starting with a in Col B, can show up in two groups, with other groups of letters in between. Any idea of what's wrong? BEO There is nothing wrong; this is the way simultaneous sorting on multiple columns is supposed to work. It keeps the related data on the same row. Consider the following table showing employees and the the award(s) they received: A B Name Award Clive J Dana K Adam Z Adam K Now you want to sort, first by Name, then Award Code. The correct result is: Adam K Adam Z Clive J Dana K Notice how "K" appears at the top, then again at the bottom--the "problem" you described. Now what if each column was sorted independently: Adam J Adam K Clive K Dana Z But this is saying Adam received award "J" -- which is not true! Hope this helps! . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More columne sorting
You needed to select all the columns before you did your sort, then sort by
column A and column B. If it stiull doesn't give the right result, you might want to produce (temporarily) a helper column with =LEFT(B2) and copy down, to check that you don't have leading spaces or other characyers which are confusing your sort. -- David Biddulph "BEOPS" wrote in message ... Sorry for beeing unclear. Relating to your exempel I get this kind of result for one specific value in Col A Adam Ka Adam Ka Adam Kb Adam Kb Adam F Adam F Adam Ka Adam Ka Adam F Adam F This is what I mean with strange grouping and is not what I expect -- BEO "smartin" wrote: BEOPS wrote: I have a quite normal worksheet with 5-6 columns filled with text info The cells are defined as text I like to sort the columnes by first col A and then by Col B. I am doing by the schoolbook (I think), meaning that I am using the data sort function, selecting first A then B. However B is sorted in a strange way, like in groups. Words starting with a in Col B, can show up in two groups, with other groups of letters in between. Any idea of what's wrong? BEO There is nothing wrong; this is the way simultaneous sorting on multiple columns is supposed to work. It keeps the related data on the same row. Consider the following table showing employees and the the award(s) they received: A B Name Award Clive J Dana K Adam Z Adam K Now you want to sort, first by Name, then Award Code. The correct result is: Adam K Adam Z Clive J Dana K Notice how "K" appears at the top, then again at the bottom--the "problem" you described. Now what if each column was sorted independently: Adam J Adam K Clive K Dana Z But this is saying Adam received award "J" -- which is not true! Hope this helps! . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
More columne sorting
.... and you might also want another helper column with =LEN(A2) and copy
down, to see whether all the "Adam" cells have only 4 characters, or whether there are again spaces or other non-printing characters which are confusing your sort. -- David Biddulph "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... You needed to select all the columns before you did your sort, then sort by column A and column B. If it stiull doesn't give the right result, you might want to produce (temporarily) a helper column with =LEFT(B2) and copy down, to check that you don't have leading spaces or other characyers which are confusing your sort. -- David Biddulph "BEOPS" wrote in message ... Sorry for beeing unclear. Relating to your exempel I get this kind of result for one specific value in Col A Adam Ka Adam Ka Adam Kb Adam Kb Adam F Adam F Adam Ka Adam Ka Adam F Adam F This is what I mean with strange grouping and is not what I expect -- BEO "smartin" wrote: BEOPS wrote: I have a quite normal worksheet with 5-6 columns filled with text info The cells are defined as text I like to sort the columnes by first col A and then by Col B. I am doing by the schoolbook (I think), meaning that I am using the data sort function, selecting first A then B. However B is sorted in a strange way, like in groups. Words starting with a in Col B, can show up in two groups, with other groups of letters in between. Any idea of what's wrong? BEO There is nothing wrong; this is the way simultaneous sorting on multiple columns is supposed to work. It keeps the related data on the same row. Consider the following table showing employees and the the award(s) they received: A B Name Award Clive J Dana K Adam Z Adam K Now you want to sort, first by Name, then Award Code. The correct result is: Adam K Adam Z Clive J Dana K Notice how "K" appears at the top, then again at the bottom--the "problem" you described. Now what if each column was sorted independently: Adam J Adam K Clive K Dana Z But this is saying Adam received award "J" -- which is not true! Hope this helps! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Help with sorting | Excel Discussion (Misc queries) |