Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Group cells during sort | Excel Discussion (Misc queries) | |||
How do I sort a group of calculated cells in Excel? | Excel Worksheet Functions | |||
Group cells and sort | Excel Programming | |||
How do i sort a group of cells from highest to lowest | Excel Discussion (Misc queries) | |||
How can I group a bunch of cells together, so I can sort by colum. | Excel Worksheet Functions |