Sorting is putting blank cells at top?

[brendan2711]

Hey guys.

I am trying to use the sort function, and for some reason it has started putting the blank cells above the rest.
i.e. A2:A102 contains around 90 cells which are fill with numbers 10-60. When I sort them Largest to Smallest, the top 10 cells are always coming up with the blank cells.

My understanding of the sort function is that blanks are always supposed to come last. Am I wrong?
I have also tried using the IF formula (they are fed by formulas) to make any blank cells into a space instead. But this is not working either.

Any suggestions?

[WasWodge]

Are your cells truly blank or are they nullstrings as the result of formula?

[brendan2711]

There are two column doing it.
One is fed by formulas
The other is not.

[WasWodge]

The easiest way around the formula column (if it is nullstrings) returned is to use a helper column and instead of using "" use a number you know will be lower than any number in the data i.e. something like

Please Login or Register  to view this content.

then sorting on that column.
You can then either hide or delete the helper column,

The cells that are not from formula are a bit more puzzling unless the data is imported from the web or from a CSV file. Do a test on to find out what they are.

Try something like CODE(B1) to see if there is a non-printing character and obviously do a nullstring test as per the formula for the helper column.

[brendan2711]

Looks Like I got it working. Thanks for the help.