Sort order

  • Thread starter Thread starter LucB
  • Start date Start date
L

LucB

Excel always sorts "blanks last". Is it possible to sort "blanks first"?
 
Perform a Search and Replace. Either replace the null
values with something that will always be first (such
as "AAAA") or a space.
 
You must log in or register to reply here.

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

Similar Threads

sort a table that contains both numbers and blank cells 1
Sorting in Excel 2
writing a sort macro 2
Custom Sorting 2
Removing blank cells 13
Sorting by rows with differing numbers of cell entries 3
Sorting Blanks? 4
Excel 2003 data sort 1

Back
Top