Sorting data

[TF]

I have a spreadsheet that has a column of numbers. Some rows have just one customer and some rows have the same customer listed numerous times. For instance I might have John Doe listed in 2 rows with varying dollar figures. In the adjacent column I have taken that customers entered a total amount for the two rows (see example)
John Doe Claire Sullivan $10
John Doe Claire Sullivan $25 $3

I have over 600 rows of information and I need to sort the data in the total amount column but I need to keep the blank cells intack and not placed at the end of the sort list. Is there a way to lock the cells and then sort the data by the total amount column in ascending order and not loose the current format of the sheet

 

[Anders S]

Not sure if I understand but one way may be to insert an extra column, for example A, and enter a sequential number series into it, that is 1, 2, 3 ... 600.

Then sort on the totals column and do whatever processing you're after. The just sort on column A to restore the table to it's original order.

HTH
Anders Silven

 

[Guest]

Hi--

I had a similar problem, and I solved it by creating a
named range called datasort. Then I created a macro that
would select the range, sort it, then de-select it. Does
this help?

Sherry

-----Original Message-----
I have a spreadsheet that has a column of numbers. Some

rows have just one customer and some rows have the same
customer listed numerous times. For instance I might have
John Doe listed in 2 rows with varying dollar figures. In
the adjacent column I have taken that customers entered a
total amount for the two rows (see example).

John Doe Claire Sullivan $10
John Doe Claire Sullivan $25 $35

I have over 600 rows of information and I need to sort

the data in the total amount column but I need to keep the
blank cells intack and not placed at the end of the sort
list. Is there a way to lock the cells and then sort the
data by the total amount column in ascending order and not
loose the current format of the sheet?