Data Sortin 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!!

Data Sortin Problem
 

look out for the cells that may be starting with a space.
On the first line of A column. In some othe rcolumn, type
=trim(a)
then index on this new column and see the difference.
if it works perfect, then rest assured that some your data contains a blank
in the beginning of the data.

click yes below, if it works

"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!!