Data Sorting Problem

D

Dado

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
can’t get it sort the entire document in one list. Please help and thank you
in advance!!
 
S

Sean Timmons

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..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top