Sort a group of cells
 

I have a spreadsheet with check numbers and amounts by date, which looks
something like:

5/6/06 5/7/06
5/8/06
102334 106.72 102359 653.40 102335 78.90
102333 1095.80 102348 780.98 102350 277.77
102339 345.76 102336 235.50

But it goes on for up to 20 check numbers. I want to sort so the first 2
columns change to:

102333 1095.80
102334 106.72
102339 345.76

....so the check numbers fore one date are in order from lowest to highest
with the correct amount with it, but the other columns remain as they are.
But I only want to sort the 3 rows and 2 columns with the rest of the
document remaining the same. The strange thing is that I have one document
where I can sort that way, and one where I can't. I've looked, but can't find
any differences that account for it.

Sort a group of cells
 

You don't say whether or not you are doing this with VBA, but it seems you
are not.

Select the data you want to sort, go to Data Sort and select criteria.

That should do it.
--
JNW


"ALF0525" wrote:

I have a spreadsheet with check numbers and amounts by date, which looks
something like:

5/6/06 5/7/06
5/8/06
102334 106.72 102359 653.40 102335 78.90
102333 1095.80 102348 780.98 102350 277.77
102339 345.76 102336 235.50

But it goes on for up to 20 check numbers. I want to sort so the first 2
columns change to:

102333 1095.80
102334 106.72
102339 345.76

...so the check numbers fore one date are in order from lowest to highest
with the correct amount with it, but the other columns remain as they are.
But I only want to sort the 3 rows and 2 columns with the rest of the
document remaining the same. The strange thing is that I have one document
where I can sort that way, and one where I can't. I've looked, but can't find
any differences that account for it.