Sorting Columns - XL 2003

G

Guest

I have a worksheet that contains data in a format something like:
ID# Name Score
1 Bill 24
2 Jack 3

4 Sue 88

The cell contents are the result of formulas referring to other parts of the
worksheet and other worksheets in the spreadsheet.
The ID# column is always sequential (incluidng the blank line), but the
other columns are in any order.

I need to sort the columns by descending score ignoring the blank lines,
giving:
ID# Name Score
4 Sue 88
1 Bill 24
2 Jack 3

Data -> Sort -> Descending insists on putting the blank line above the others:

ID# Name Score

1 Sue 88

I seem to remember that there is a difference between a blank cell and an
empty cell, though I never understood what it was :) Could this be the
problem (a hangover from the formula that is populating each cell)? If not,
does anyone have any suggestions as this is driving me up the wall?

I have tried to copy and paste to other areas using the Paste Special ->
Values ans Skip Blanks options but this has not made any difference.

TIA
 
P

Puppet_Sock

Risky said:
I have a worksheet that contains data in a format something like:
ID# Name Score
1 Bill 24
2 Jack 3

4 Sue 88

The cell contents are the result of formulas referring to other parts of the
worksheet and other worksheets in the spreadsheet.
The ID# column is always sequential (incluidng the blank line), but the
other columns are in any order.

I need to sort the columns by descending score ignoring the blank lines,
giving:
ID# Name Score
4 Sue 88
1 Bill 24
2 Jack 3

Data -> Sort -> Descending insists on putting the blank line above the others:

ID# Name Score

1 Sue 88

I seem to remember that there is a difference between a blank cell and an
empty cell, though I never understood what it was :) Could this be the
problem (a hangover from the formula that is populating each cell)? If not,
does anyone have any suggestions as this is driving me up the wall?

I have tried to copy and paste to other areas using the Paste Special ->
Values ans Skip Blanks options but this has not made any difference.

You probably have space chars in the source cells. There are several
things you could do. Try taking out the blanks from empty source cells.
Socks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top