Hello David,

Thank you very much for the instructions.

I thought that the re-ordering would be quite difficult to achieve. On the
contrary, your instructions made it quite easy.

Much appreciated!

Regards,

Martin

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
| Select your data range, including all the relevant rows and columns. Then
| Data/ Sort by .../ and choose the relevant column by which to sort.
| --
| David Biddulph
|
| "Martin" wrote in message
| .. .
| Hello,
|
| I'm 100% new to Excel (btw, I have Excel 2002) and need assistance with
| the
| following, please.
|
| I have an Excel spreadsheet, running many hundreds of pages, that has 7
| columns.
|
| They are, from left to right, as follows:
|
| 1. Person's name
| 2. Person's street address
| 3. Person's city
| 4. Person's state
| 5. Person's Zip code
| 6. Reference number assigned to the person
| 7. Monetary amount
|
| The *current* spreadsheet is neither in alphabetical nor numerical
order.
|
| For example, 3 consecutive entries may appear as:
|
| Poe, John 895 Main Street New York NY 10120 753 6.20
| Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|
| What I would like to do is re-order the spreadsheet by *monetary
amount*,
| as
| long as the data associated with each amount is maintained by the same
| re-ordering.
|
| To be more specific, I wish the spreadsheet to appear as:
|
| Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
| Poe, John 895 Main Street New York NY 10120 753 6.20
| Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
|
| OR
|
| Allan, David 456 Pear Ave Iselin NJ 08830 421 342.57
| Poe, John 895 Main Street New York NY 10120 753 6.20
| Doe, Jane 567 Oscar Street Atlanta GA 77731 525 1.23
|
| Any help would be greatly appreciated!
|
| Thank you.
|
| Martin
|
|
|
|
|