| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Blanks First | New Users to Excel | |||
| sorting data that contains blanks | Excel Discussion (Misc queries) | |||
| sorting column with blanks | Excel Worksheet Functions | |||
| Help with sorting blanks out of a list | Excel Discussion (Misc queries) | |||
| Sorting by looking for blanks | Excel Discussion (Misc queries) | |||
Hybrid Mode
