Sorting Blanks?

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Excel2003 ... I have formulas which calculate some cells to ... "" ... Blank

Issue ... When I sort these cells the "" (Blanks) come to the top ... I wish
to disregard the blanks & not have them sort to the Top.

Can I do this? ... How? ... Thank ... Kha
 
Maybe you can add another column to the range to be sorted and use a formula
that returns a value that would sort to the bottom of the range.

=if(a1="",rept("z",255),a1)

Then drag down the range and sort by this field.
 
Problem is ... I need to sort "Ascending" as well as "Descending" ... In
either case I wish the cells carrying the "" (blank) to be @ the bottom ...

Thanks ... Kha
 
Change the formula to return what you want before you sort. Just make it larger
than the largest value or smaller than the smallest.
 
add one more column to dave's answer wherein
=if(a1="","a",a1)
Then drag down the range and sort by this field.

learn - n - enjoy
 

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

Back
Top