can I sort only part of one column?
can I sort only part of one column?

Hi,
recently I've been pondering if it's possible to sort only certain rows in one column.
For example... in one column, I have a lot of numbers and then a "-" in the place where numbers arent relevant to the overall item... would look something like this:
|_column_|
|___1_____|
|___4_____|
|___2_____|
|___9_____|
|___-_____|
|___-_____|
|___-_____|
|___-_____|
|___-_____|
Is it possible to make it so that when clicking the header to sort, only the rows with numbers are affect, leaving the "-"-rows static and unaffected... remaining right where they are?
recently I've been pondering if it's possible to sort only certain rows in one column.
For example... in one column, I have a lot of numbers and then a "-" in the place where numbers arent relevant to the overall item... would look something like this:
|_column_|
|___1_____|
|___4_____|
|___2_____|
|___9_____|
|___-_____|
|___-_____|
|___-_____|
|___-_____|
|___-_____|
Is it possible to make it so that when clicking the header to sort, only the rows with numbers are affect, leaving the "-"-rows static and unaffected... remaining right where they are?
This discussion has been closed.
Replies
Allan