sort function

[white6174]

does anyone know a good sort function.
I've tryed the built in one and one I got out of a book but they dont work right.

When I'm sorting data in a column it doesn't handle blanks the way I want it to.
It wont always sink the blanks, it will leave the blanks at the bottom if they're already there, but not sink the ones in the middle of data.

example
4
3

6
8
1

7
It leaves these blanks in the same spots but it sorts the data


thanks for any help

steve w

 

[Chris Davison]

On 2002-05-12 08:47, white6174 wrote:

does anyone know a good sort function.
I've tryed the built in one and one I got out of a book but they dont work right.

When I'm sorting data in a column it doesn't handle blanks the way I want it to.
It wont always sink the blanks, it will leave the blanks at the bottom if they're already there, but not sink the ones in the middle of data.

example
4
3

6
8
1

7
It leaves these blanks in the same spots but it sorts the data


thanks for any help

steve w

Hi Steve,

no, this doesn't sound right at all.

You're definitely sorting on that specific column ?

Are those blank cells actually blank ? Somebody hasn't sneakily changed the contents' font colour to white to make them look like they're blank, have they ?

can you also just check a few of them : interrogate them with =ISBLANK(cell) where cell is the cell reference

if they're blank, the results should be "FALSE"

 

[Jack in the UK]

Chris these cellsmust no be blanks else sort will shuffle to bottom regardless..

your call is spot on... could be many reasons

fastes fix i wold say is:

simply autofilter the colm to blanks and clear contence not delete or clean up and them re try.. forget the reasons if they are set to blank/ enpty call as you do sort can not fail.