Sorting Blanks?

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
 
D

Dave Peterson

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

Ken

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
 
D

Dave Peterson

Change the formula to return what you want before you sort. Just make it larger
than the largest value or smaller than the smallest.
 
Y

YESHWANT

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

Similar Threads


Top