Sorting Blanks?
 

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

Sorting Blanks?
 

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.

Ken wrote:

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

--

Dave Peterson

Sorting Blanks?
 

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

"Dave Peterson" wrote:

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.

Ken wrote:

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

--

Dave Peterson
.

Sorting Blanks?
 

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

Ken wrote:

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

"Dave Peterson" wrote:

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.

Ken wrote:

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

--

Dave Peterson
.


--

Dave Peterson