Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Newbie...How To Re-Order Data
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
newbie needs help with data storage | Excel Discussion (Misc queries) | |||
Newbie Order-Entry Macro | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |