Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Sorting Problem
Hello,
In case of sorting large data alphabetically, once I do sorting function of data by name in column A it creates two sorted lists, for example 100 names, it sorts 20 from A to Z and than remaining 80 names AGAIN from A to Z. I cant get it sort the entire document in one list. Please help and thank you in advance!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Sorting Problem
Sounds like perhaps some of the data has a space in front of it. Either that
or you may have a blank row in between... if the second, just highlight the whole workbook and sort.. "Dado" wrote: Hello, In case of sorting large data alphabetically, once I do sorting function of data by name in column A it creates two sorted lists, for example 100 names, it sorts 20 from A to Z and than remaining 80 names AGAIN from A to Z. I cant get it sort the entire document in one list. Please help and thank you in advance!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Sorting Problem
Could it be that some are in uppercase and some in lowercase?
"Sean Timmons" wrote: Sounds like perhaps some of the data has a space in front of it. Either that or you may have a blank row in between... if the second, just highlight the whole workbook and sort.. "Dado" wrote: Hello, In case of sorting large data alphabetically, once I do sorting function of data by name in column A it creates two sorted lists, for example 100 names, it sorts 20 from A to Z and than remaining 80 names AGAIN from A to Z. I cant get it sort the entire document in one list. Please help and thank you in advance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem sorting data | Excel Discussion (Misc queries) | |||
Data sorting problem | Excel Discussion (Misc queries) | |||
Problem with Sorting Data | Excel Discussion (Misc queries) | |||
data sorting problem | Excel Worksheet Functions | |||
data sorting problem | Excel Worksheet Functions |